 |
 | 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 2007mail 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? 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.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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? Thanks for the response, but unfortunately it didn't work. I wasn't given the option of using DDE. Other suggestions? > 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 [quoted text clipped - 6 lines] > > Codes are being merged. Data appears in Excel spreadsheet but is not > > appearing in Mail Merge Receipients window. What should I do? See the Excel Data section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm Do you get the dialogs shown there? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thanks for the response, but unfortunately it didn't work. I wasn't > given the option of using DDE. Other suggestions? [quoted text clipped - 18 lines] >>> Codes are being merged. Data appears in Excel spreadsheet but is not >>> appearing in Mail Merge Receipients window. What should I do? Wow, this is going to take time to review. Thanks, I'll get back to you. > See the Excel Data section of > http://www.gmayor.com/mail_merge_labels_with_word_xp.htm Do you get the [quoted text clipped - 22 lines] > >>> Codes are being merged. Data appears in Excel spreadsheet but is not > >>> appearing in Mail Merge Receipients window. What should I do? The issue is resolved. Thanks for your assistance. > See the Excel Data section of > http://www.gmayor.com/mail_merge_labels_with_word_xp.htm Do you get the [quoted text clipped - 22 lines] > >>> Codes are being merged. Data appears in Excel spreadsheet but is not > >>> appearing in Mail Merge Receipients window. What should I do? You are welcome :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > The issue is resolved. Thanks for your assistance. > [quoted text clipped - 32 lines] >>>>> Codes are being merged. Data appears in Excel spreadsheet but is >>>>> not appearing in Mail Merge Receipients window. What should I do? |
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.