| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge missing records
My problem is similar to marti's. I'm working with Excel 2003 and Word 2003,
merging into labels. Out of 2000 records, only 15 Zip Codes are being merged. Data appears in Excel spreadsheet but is not appearing in Mail Merge Receipients window. What should I do? |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
mail merge missing records
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: My problem is similar to marti's. I'm working with Excel 2003 and Word 2003, merging into labels. Out of 2000 records, only 15 Zip Codes are being merged. Data appears in Excel spreadsheet but is not appearing in Mail Merge Receipients window. What should I do? |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
mail merge missing records
Thanks for the response, but unfortunately it didn't work. I wasn't given
the option of using DDE. Other suggestions? "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: My problem is similar to marti's. I'm working with Excel 2003 and Word 2003, merging into labels. Out of 2000 records, only 15 Zip Codes are being merged. Data appears in Excel spreadsheet but is not appearing in Mail Merge Receipients window. What should I do? |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
mail merge missing records
See the Excel Data section of
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Do you get the dialogs shown there? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: Thanks for the response, but unfortunately it didn't work. I wasn't given the option of using DDE. Other suggestions? "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: My problem is similar to marti's. I'm working with Excel 2003 and Word 2003, merging into labels. Out of 2000 records, only 15 Zip Codes are being merged. Data appears in Excel spreadsheet but is not appearing in Mail Merge Receipients window. What should I do? |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
mail merge missing records
Wow, this is going to take time to review. Thanks, I'll get back to you.
"Graham Mayor" wrote: See the Excel Data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Do you get the dialogs shown there? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: Thanks for the response, but unfortunately it didn't work. I wasn't given the option of using DDE. Other suggestions? "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: My problem is similar to marti's. I'm working with Excel 2003 and Word 2003, merging into labels. Out of 2000 records, only 15 Zip Codes are being merged. Data appears in Excel spreadsheet but is not appearing in Mail Merge Receipients window. What should I do? |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
mail merge missing records
The issue is resolved. Thanks for your assistance.
"Graham Mayor" wrote: See the Excel Data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Do you get the dialogs shown there? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: Thanks for the response, but unfortunately it didn't work. I wasn't given the option of using DDE. Other suggestions? "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: My problem is similar to marti's. I'm working with Excel 2003 and Word 2003, merging into labels. Out of 2000 records, only 15 Zip Codes are being merged. Data appears in Excel spreadsheet but is not appearing in Mail Merge Receipients window. What should I do? |
|
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
mail merge missing records
You are welcome
 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: The issue is resolved. Thanks for your assistance. "Graham Mayor" wrote: See the Excel Data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Do you get the dialogs shown there? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: Thanks for the response, but unfortunately it didn't work. I wasn't given the option of using DDE. Other suggestions? "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Hogan wrote: My problem is similar to marti's. I'm working with Excel 2003 and Word 2003, merging into labels. Out of 2000 records, only 15 Zip Codes are being merged. Data appears in Excel spreadsheet but is not appearing in Mail Merge Receipients window. What should I do? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail Merge - Skipping records | Microsoft Word Help | |||
| mail merge missing records | Mailmerge | |||
| Missing Records in Word Mail Merge | Microsoft Word Help | |||
| Combine Mail Merge records when different records have 1 common fi | Mailmerge | |||
| missing records in mail merge documents | Mailmerge | |||
Linear Mode
