create multiple labels using a variable in the source file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert - 22 Oct 2003 05:20 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 22 Oct 2003 10:01 GMT

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

> Is there a way to create multiple labels using a variable
> in the source file to indicate the number "merges"
[quoted text clipped - 8 lines]
> the quantity variable to in essence replicate the merge
> for each label?

Reply to this Message

Robert - 22 Oct 2003 23:04 GMT

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

>-----Original Message-----
>Hi Robert,
[quoted text clipped - 29 lines]
>
>.

Reply to this Message

Doug Robbins - Word MVP - 23 Oct 2003 11:00 GMT

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

> Doug,
>
[quoted text clipped - 55 lines]
> >
> >.

Reply to this Message