Mail Merge specific amounts of line items

[Mike C]

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?

 

[Doug Robbins - Word MVP]

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