 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2005Mail Merge Problem
When I do a mail merge in Word 2003 with an Excel file, the merge happens, yet whrn I try to print, a 98 person database becomes 98 pages of mailing lables. First sheet prints ok. Second sheet drops first name from first sheet, moves second name from first sheet to first name on second sheet, third sheet drops first 2 names and moves third name to first position on third sheet. This continues until the very end. I am going crazy. Happens on work machine as well as home machine with different files. Am I missing something??  SignaturePeter Pattengill 1. In the ail merge main document, there should be a { NEXT } (i.e. <<Next Record>> ) field at the beginning of each label except the first 2. You need to perform the merge, either directly to the printer or to an output document. (see the last couple of panes in the Mail Merge Wizard). Just using File|Print or the Print toolbar button is not enough. Peter Jamieson > When I do a mail merge in Word 2003 with an Excel file, the merge happens, > yet whrn I try to print, a 98 person database becomes 98 pages of mailing [quoted text clipped - 6 lines] > missing > something?? Yes, the <next record does appear and while I haven't performed the mm to a new document or directly to the printer, I'll try that. Thanks and I'll let you know if it works. SignaturePeter Pattengill > 1. In the ail merge main document, there should be a { NEXT } (i.e. <<Next > Record>> ) field at the beginning of each label except the first [quoted text clipped - 14 lines] > > missing > > something?? If it doesn't, see where what you are doing differs from http://www.gmayor.com/mail_merge_labels_with_word_xp.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Yes, the <next record does appear and while I haven't performed the > mm to a new document or directly to the printer, I'll try that. [quoted text clipped - 22 lines] >>> -- >>> Peter Pattengill Graham: You are a life saver. Thank you so much. In looking through lots of the postings, I noticed your name quite frequently and hoped you would respond as you seem to know just what to do. Thanks for the added web sites as well. SignaturePeter Pattengill > If it doesn't, see where what you are doing differs from > http://www.gmayor.com/mail_merge_labels_with_word_xp.htm [quoted text clipped - 25 lines] > >>> -- > >>> Peter Pattengill I usually leave questions that have been answered, unless I don't understand the answer ;) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham: You are a life saver. Thank you so much. In looking > through lots of the postings, I noticed your name quite frequently [quoted text clipped - 38 lines] >>>>> -- >>>>> Peter Pattengill |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.