Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging labels from excel starts second page with second record
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging labels from excel starts second page with second record
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_lab...th_word_xp.htm -- 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 "Debbie" Debbie @discussions.microsoft.com wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating, merging, drawing lines, page numbers | Microsoft Word Help | |||
I need help when merging...I have documents I think I need as labels | Mailmerge | |||
Header & Footer not on first page but on subsequent pages | Microsoft Word Help | |||
Page number difficulties | Microsoft Word Help | |||
FIrst page footers | Microsoft Word Help |