Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Missing Records
I recently did a mail merge of names of diners and a brief bio of each person
for a booklet to accompany a dinner, using data from an Excel spreadsheet. The first time the mail merge returned about 40 records, just less than half the number that it should have. The second time it returned four short of the required number and the third time I tried there were three records missing. I am using Word and Excel 2007. The next day I used the same spreadsheet to mail merge the names of diners onto place cards, and it worked perfectly! Has anyone come across this and is there a solution? I use mail merge a huge amount and need to be able to trust that the records returned will be correct. Thanks -- FarGardener |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Missing Records
I have never heard of irregularities such as that. The usual cause is the
inclusion of a Next Record field where one is not required. -- 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 "FarGardener" wrote in message ... I recently did a mail merge of names of diners and a brief bio of each person for a booklet to accompany a dinner, using data from an Excel spreadsheet. The first time the mail merge returned about 40 records, just less than half the number that it should have. The second time it returned four short of the required number and the third time I tried there were three records missing. I am using Word and Excel 2007. The next day I used the same spreadsheet to mail merge the names of diners onto place cards, and it worked perfectly! Has anyone come across this and is there a solution? I use mail merge a huge amount and need to be able to trust that the records returned will be correct. Thanks -- FarGardener |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Missing Records
Yes, I came across this problem many years ago but it isn't relevant in this
case as the Next record fields were correctly positioned. The merge also changed my font and font size, but only for 2 or 3 records. The whole thing was very weird! -- FarGardener "Doug Robbins - Word MVP" wrote: I have never heard of irregularities such as that. The usual cause is the inclusion of a Next Record field where one is not required. -- 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 "FarGardener" wrote in message ... I recently did a mail merge of names of diners and a brief bio of each person for a booklet to accompany a dinner, using data from an Excel spreadsheet. The first time the mail merge returned about 40 records, just less than half the number that it should have. The second time it returned four short of the required number and the third time I tried there were three records missing. I am using Word and Excel 2007. The next day I used the same spreadsheet to mail merge the names of diners onto place cards, and it worked perfectly! Has anyone come across this and is there a solution? I use mail merge a huge amount and need to be able to trust that the records returned will be correct. Thanks -- FarGardener |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge from Outlook missing records | Mailmerge | |||
Some records missing data after merge | Mailmerge | |||
mail merge missing records | Mailmerge | |||
Missing records | Mailmerge | |||
missing records | Mailmerge |