If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Missing merge data in new document
After creating a main mail merge document in Word, using
Access 2003 as the database, I review the "view merged data" and all mail merge recipients are viewable. When I "merge to a new document" not all recipients are merged even though ALL are selected in "mail merge recipients". There's no consistency to which data gets pulled into the new document. |
#2
|
|||
|
|||
Hi Katie,
Default OLE DB connections with Access and Excel do sometimes manifest problems. See if this helps: Tools/Options/General, activate "Confirm conversions on open". Now link up to the Access database again. This time, you'll get a list of available connection methods. Try ODBC. If you're linking to a query, click "Options" and activate "Views" to append a list of queries to the list of tables. Select the data table/query. After creating a main mail merge document in Word, using Access 2003 as the database, I review the "view merged data" and all mail merge recipients are viewable. When I "merge to a new document" not all recipients are merged even though ALL are selected in "mail merge recipients". There's no consistency to which data gets pulled into the new document. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to run word and pass a mail merge values and fax it to the recipient | Belinda | Mailmerge | 2 | June 13th, 2004 12:49 AM |
Merge Document will not retain data | Susan | Mailmerge | 1 | June 6th, 2004 11:07 AM |
Lost text fields in merge | CGiannini | General Discussion | 5 | June 4th, 2004 10:23 PM |
Word mail merge with Excel data | Peter Jamieson | Mailmerge | 1 | April 26th, 2004 07:30 PM |
Merging Excel Data into Word Document | Debra Dalgleish | Worksheet Functions | 1 | February 16th, 2004 12:15 AM |