Label Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nik - 27 May 2004 11:40 GMT

I am merging 1186 records from xl in XP Pro onto an avery
7161 label, I get the merge to work but when I look at
page 2 all it does is remove the first address and move
the second one to the start so i end up with 1186 pages
of 18 labels to print when I should only be printing 66
pages of labels?

Reply to this Message

Peter Jamieson - 27 May 2004 13:22 GMT

It sounds as if you are /previewing/ the merge. You need to complete the
merge (e.g. merge to printer, or merge to a new document then print it, if
you want to be sure it works before committing to paper :-) )

Signature

Peter Jamieson

> I am merging 1186 records from xl in XP Pro onto an avery
> 7161 label, I get the merge to work but when I look at
> page 2 all it does is remove the first address and move
> the second one to the start so i end up with 1186 pages
> of 18 labels to print when I should only be printing 66
> pages of labels?

Reply to this Message

- 18 Jun 2004 21:40 GMT

hey nik,

Did you fix this problem, if so can you please post how
you did
thanks in advance

>-----Original Message-----
>I am merging 1186 records from xl in XP Pro onto an avery
[quoted text clipped - 4 lines]
>pages of labels?
>.

Reply to this Message

Doug Robbins - Word MVP - 19 Jun 2004 01:26 GMT

In the mailmerge main document, each label other than the first one on the
sheet should have a <<Next Record>> field before the first mergefield in the
cell. Either these got deleted somehow, or the "Replicate Label" step got
missed.

See the article "Mail Merge Labels with Word XP" on fellow MVP Graham Mayor'
s website at

http://www.gmayor.com/multiple_mail_merge_entries.htm

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

> hey nik,
>
[quoted text clipped - 10 lines]
> >pages of labels?
> >.

Reply to this Message