Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge specific amounts of line items
I have a list of products in Excel that I need to make labels for. Column A
has the product name and column B has the amount of lables I need. I want to create a Mail Merge (or any others solution possible) that prints the amount of labels for each product indicated in column B. For example, if Widgets is in Column A and 42 next to it, the mail merge would create 42 labels, then move on to the next product. Any ideas? -- MC |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge specific amounts of line items
Macropod, the Field Wizard may be able to come up with a Field construction
for this, but I would use Visual Basic. First I would use a catalog or directory type mailmerge to get the information into the form of a Word table, then I would use a macro to open a new document that was based on the label template and then iterate through the rows of the table in the document created by the catalog merge, populating the cells of the label template document with the require number of each label before moving on to the next row in the table. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Mike C" wrote in message ... I have a list of products in Excel that I need to make labels for. Column A has the product name and column B has the amount of lables I need. I want to create a Mail Merge (or any others solution possible) that prints the amount of labels for each product indicated in column B. For example, if Widgets is in Column A and 42 next to it, the mail merge would create 42 labels, then move on to the next product. Any ideas? -- MC |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
mail merging formatted content | Mailmerge | |||
Horizontal Line not printing after second page in mail merge | Mailmerge | |||
Mail merge - use specific fields in the contacts folder to customi | Mailmerge | |||
How do I keep a blank line from printing in a mail merge? Record. | Mailmerge |