Mail Merge specific amounts of line items

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike C - 06 Oct 2006 20:26 GMT

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?

Signature

Reply to this Message

Doug Robbins - Word MVP - 07 Oct 2006 07:04 GMT

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.

Signature

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

>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
[quoted text clipped - 5 lines]
> in Column A and 42 next to it, the mail merge would create 42 labels, then
> move on to the next product. Any ideas?

Reply to this Message