Label merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Moe E. - 29 Mar 2004 07:29 GMT

Hi, I am using word 2002 to print labels using mail
merge. Is there a way to write a macro in mail merge or
so that when one uses the mail merge, it will ask you how
many leading balnk labels do you want to be printed
before the actual data records? And if the answer is yes,
then how is it done?

Thank you

Moe E.

Reply to this Message

Doug Robbins - Word MVP - 31 Mar 2004 14:03 GMT

I would suggest that the easiest thing to do is to insert n blank records at
the start of the data source where n is a number one less than the number of
labels on the sheet. Then if you turn on the Mailmerge toolbar in Word
(View Toolbars, you can click on the Mailmerge recipients button and uncheck
the necessary number of blank records so that the required number of blank
records remain to be merged, thus forcing the first record that contains
data down the sheet of labels to the required position.

Signature

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

> Hi, I am using word 2002 to print labels using mail
> merge. Is there a way to write a macro in mail merge or
[quoted text clipped - 6 lines]
>
> Moe E.

Reply to this Message