Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Skip 1st Record in Merge when Merging To Attendee Roster & Name Ba
I export my records into Excel and see that it is does not print a record in
the first place where a record should appear on the attendee roster (directory), it does however, insert Phone: and Email: I'm willing to work with this as I only need to delete those two words and the directory is fine. But my merge will not print the first record on the name badge. It placed it in the 2nd place of the name badge. I was plagued with skipping records last year, and I pulled a new Avery badge template from my version at home and bought it to work and the skipping of records stopped. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Skip 1st Record in Merge when Merging To Attendee Roster & Name Ba
You probably have a Next record field where one is not required.
See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Satterbury wrote: I export my records into Excel and see that it is does not print a record in the first place where a record should appear on the attendee roster (directory), it does however, insert Phone: and Email: I'm willing to work with this as I only need to delete those two words and the directory is fine. But my merge will not print the first record on the name badge. It placed it in the 2nd place of the name badge. I was plagued with skipping records last year, and I pulled a new Avery badge template from my version at home and bought it to work and the skipping of records stopped. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Skip 1st Record in Merge when Merging To Attendee Roster & Nam
Hi Graham, I just checked and no I don't have a "next record" on the first entry. Would you like to see both my badge and directory template as well as the Excel file? "Graham Mayor" wrote: You probably have a Next record field where one is not required. See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Satterbury wrote: I export my records into Excel and see that it is does not print a record in the first place where a record should appear on the attendee roster (directory), it does however, insert Phone: and Email: I'm willing to work with this as I only need to delete those two words and the directory is fine. But my merge will not print the first record on the name badge. It placed it in the 2nd place of the name badge. I was plagued with skipping records last year, and I pulled a new Avery badge template from my version at home and bought it to work and the skipping of records stopped. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Skip 1st Record in Merge when Merging To Attendee Roster & Nam
If on the directory you get
Blank Phone Email Name Phone Email Name Phone Email where on the first line, the Phone and Email are correct for the first record and the data for the other records is correct, I think that the issue is with the data for the first record in the datasource. -- 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 "Satterbury" wrote in message ... Hi Graham, I just checked and no I don't have a "next record" on the first entry. Would you like to see both my badge and directory template as well as the Excel file? "Graham Mayor" wrote: You probably have a Next record field where one is not required. See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Satterbury wrote: I export my records into Excel and see that it is does not print a record in the first place where a record should appear on the attendee roster (directory), it does however, insert Phone: and Email: I'm willing to work with this as I only need to delete those two words and the directory is fine. But my merge will not print the first record on the name badge. It placed it in the 2nd place of the name badge. I was plagued with skipping records last year, and I pulled a new Avery badge template from my version at home and bought it to work and the skipping of records stopped. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Skip 1st Record in Merge when Merging To Attendee Roster & Nam
If Doug's suggestion does not work and the files when zipped are small
enough to e-mail, send them to the link on the home page of my web site and I will have a look over the weekend. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Satterbury wrote: Hi Graham, I just checked and no I don't have a "next record" on the first entry. Would you like to see both my badge and directory template as well as the Excel file? "Graham Mayor" wrote: You probably have a Next record field where one is not required. See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Satterbury wrote: I export my records into Excel and see that it is does not print a record in the first place where a record should appear on the attendee roster (directory), it does however, insert Phone: and Email: I'm willing to work with this as I only need to delete those two words and the directory is fine. But my merge will not print the first record on the name badge. It placed it in the 2nd place of the name badge. I was plagued with skipping records last year, and I pulled a new Avery badge template from my version at home and bought it to work and the skipping of records stopped. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skip record if... | Mailmerge | |||
mailmerge. end merge or skip record when quantity is 0 | Mailmerge | |||
Why does Label Mail Merge skip first record on subsequent pages | Mailmerge | |||
label merge only 1st record is merging-rest of source won't merge | Mailmerge | |||
merge is only merging every 3rd record - how do i fix it? | Mailmerge |