Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Word mail merge with Access
Why does Word sometimes open another instance of Access when doing a mail
merge? I have forms in Access with hyperlinks to Word merge documents which are based on queries from the form info. They were working flawlessly. Now, Word is opening another instance of access and the queries are not returning any data because the form info is not available in the new instance of Access. The only thing I have done different is set up Access to open the switchboard when opened and I set warnings to off in several of the macros that I run. What would cause Word to start opening another instance of Access? |
#2
|
|||
|
|||
This is known problem
(it happens when you change the name of your database). A description and fix is mentioned he http://www.mvps.org/access/bugs/bugs0011.htm On the other hand, you might try my sample "super easy word" merge. Not only does my example avoid your problem, but also allows you to easily merge just ONE record. You can give the sample a download he http://www.attcanada.net/~kallal.msn.../msaccess.html If it does what you want..then you can read the instructions on how to use the neat code in your application. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.attcanada.net/~kallal.msn |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
Mail merge - Word 2003/Access 2000 | Mailmerge | |||
Word 2003 and Access 2003 Mail Merge question | Microsoft Word Help | |||
Mail merge toolbar unavailable after SP3 | Mailmerge | |||
Word mail merge doesn't pick up the addresses in Access database. | Tables |