Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Debbie
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formating, merging, drawing lines, page numbers vimesfan Microsoft Word Help 2 December 29th 05 04:38 PM
I need help when merging...I have documents I think I need as labels sparks Mailmerge 3 October 10th 05 01:51 PM
Header & Footer not on first page but on subsequent pages KM1 Microsoft Word Help 14 June 13th 05 12:36 AM
Page number difficulties Tjodrik Microsoft Word Help 3 May 9th 05 02:54 PM
FIrst page footers Noel S Pamfree Microsoft Word Help 7 December 6th 04 08:49 PM


All times are GMT +1. The time now is 06:08 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"