Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail 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?? -- Peter Pattengill |
#2
|
|||
|
|||
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 "Peter Pattengill" wrote in message ... 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?? -- Peter Pattengill |
#3
|
|||
|
|||
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. -- Peter Pattengill "Peter Jamieson" wrote: 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 "Peter Pattengill" wrote in message ... 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?? -- Peter Pattengill |
#4
|
|||
|
|||
If it doesn't, see where what you are doing differs from
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Pattengill wrote: 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. 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 "Peter Pattengill" wrote in message ... 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?? -- Peter Pattengill |
#5
|
|||
|
|||
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. -- Peter Pattengill "Graham Mayor" wrote: If it doesn't, see where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Pattengill wrote: 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. 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 "Peter Pattengill" wrote in message ... 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?? -- Peter Pattengill |
#6
|
|||
|
|||
I usually leave questions that have been answered, unless I don't understand
the answer -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Pattengill wrote: 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. If it doesn't, see where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Pattengill wrote: 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. 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 "Peter Pattengill" wrote in message ... 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?? -- Peter Pattengill |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
Problem with automating mail merge | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge | |||
Mail Merge Problem w/ MS Word 2000 | Mailmerge | |||
Mail Merge Problem | Mailmerge |