Home |
Search |
Today's Posts |
#1
|
|||
|
|||
access-word merge - tables and queries disappear
i have a database in access 2002 with 10 tables and 7 queries. when i try to
mail merge it with word, only 5 tables and 4 queries are visible. the rest of them just aren't there. i have no idea what to do...any tips or suggestions would be greatly appreciated, thanks! |
#2
|
|||
|
|||
In Word, check Tools|Options|General|Confirm conversion at open, reconnect
to your Access database, and select the DDE option when offered. This will only work if you have Access on your machine. As background, Word can use several different methods to connect to Access (Jet) data: DDE, ODBC, and in Word 2002 and later, OLEDB. ODBC and OLEDB cannot work with certain types of query - for example, parameter queries - in that case Word does not provide the parameter information and neither OLEDB nor ODBC will do so. Peter Jamieson "uc user" uc wrote in message ... i have a database in access 2002 with 10 tables and 7 queries. when i try to mail merge it with word, only 5 tables and 4 queries are visible. the rest of them just aren't there. i have no idea what to do...any tips or suggestions would be greatly appreciated, thanks! |
#3
|
|||
|
|||
thanks, i will give that a shot!
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge - Word 2003/Access 2000 | Mailmerge | |||
Mail Merge Recipient List | Mailmerge | |||
Splitting text from mail merge fields | Mailmerge | |||
How do I Mail Merge from an Access Query? | Mailmerge | |||
mailmerging multiple tables from access in one word-document: how? | Mailmerge |