Merging labels from excel starts second page with second record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debbie - 08 Feb 2006 19:02 GMT

When merging labels from an excel file, the second page of the labels starts
with the second record from the excel file and repeats all the other labels,
third page starts with third label (sheets of 30 labels each), etc. How do I
get the merge wizard to start page 2 of labels with appropriate record - on a
30-label sheet, it should start page 2 with label #31. Any suggestions?

Reply to this Message

Doug Robbins - Word MVP - 08 Feb 2006 19:17 GMT

I would be 99% sure that you are not actually executing the merge. Rather,
you are previewing the result of the merge, then printing the sheet and then
moving to the next record and previewing (well maybe not really) and then
printing.

I would also be 99% sure that you are using the Mail Merge wizard that comes
with Word XP or 2003. Instead of doing that, from the View menu, select
Toolbars and then check the Mail Merge toolbar item. Then use either the
third button from the right hand end of the Mail Merge toolbar to execute
the merge to the Printer.

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

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When merging labels from an excel file, the second page of the labels
> starts
[quoted text clipped - 5 lines]
> on a
> 30-label sheet, it should start page 2 with label #31. Any suggestions?

Reply to this Message