Mail Merge

  • Thread starter Thread starter Aaron Neunz
  • Start date Start date
A

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
 
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?
Click to expand...
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 :-)
 
Back
Top