create multiple labels using a variable in the source file

[Robert]

Is there a way to create multiple labels using a variable
in the source file to indicate the number "merges"
needed?

I need to merge multiple mailing labels based on an excel
source file field. So, in Excel, I have a name and
address and another field to indicate how many labels I
need for that record. All the quantity of labels will be
different, that is to say, I may need one of this one,
but 4 of that one, and 10 of yet another. How can I use
the quantity variable to in essence replicate the merge
for each label?

 

[Doug Robbins - Word MVP]

Hi Robert,

Your best bet would be to use a macro in Excel that made use of the quantity
variable to create another worksheet with the appropriate number of
replications of each record in it so that you could just do a straight
forward merge in Word. It's either that or use a macro in Word and scrap
the mailmerge idea altogether.

See the article "Control Excel from Word" at:

http://www.mvps.org/word/FAQs/InterDev/ControlXLFromWord.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Robert]

Doug,

Thanks for your help I likr the Excel idea and will
follow up with it. I can write the code for the macro but
I am not sure how to call an instance of an Excel
workbook or move data to another worksheet. If anyone
knows of reasources they would be greatly appreciated.

Thanks again,

Robert

 

[Doug Robbins - Word MVP]

Hi Robert,

You should post this question to the microsoft.public.excel.programming
newsgroup

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP