Mail Merge

[Aaron Neunz]

I am doing a simple mail merge. My data source is an Excel worksheet. I
have two fields Precinct_Name and Devices. My main Word document are
mailing labels (Avery 5160). The printed labels will have the contents of
the Precinct_Name field. I need to print the number of labels based on the
amount in the Devices field. How can I accomplish this?




Thanks in advance,
Aaron Neunz

 

[Cindy M -WordMVP-]

Hi Aaron,

I am doing a simple mail merge. My data source is an Excel worksheet. I
have two fields Precinct_Name and Devices. My main Word document are
mailing labels (Avery 5160). The printed labels will have the contents of
the Precinct_Name field. I need to print the number of labels based on the
amount in the Devices field. How can I accomplish this?

Basically, you can't. Word's mail merge just doesn't support anything like
this. Best plan of attack would be a macro in Excel that would create a
second sheet of records, with all the required entries (labels) you'll need.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail