I would like to mail merge a Word 2007 document with data from a query in Access 2007. However, I have password protected the database and the mail merge wizard can't handle it. Is ther a work around shot of disabling the password protection?

Thank you in advance for any assistance.

Cross-posted at: http://answers.microsoft.com/en-us/o...c-68b599b31bf5

For cross-posting etiquette, please see: http://www.excelguru.ca/node/7

For a possible solution, see: http://www.tech-archive.net/Archive/.../msg00180.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Sorry about the cross posting. I was unaware, very new at this. Your etiquette article was very informative, and made a great deal of sense. The few times I've posted I have sometime cross posted, and didn't realize the interconnected nature of the great individuals who are volunteering. The responses have been very helpful. I went to the possible solution you recommended, and the Data Link Properties seemed to be looking for a server workgroup, or user name and password to log onto a server. I'm alrady logged onto a Novel server. In an effort to test, I copied the database to my desktop, but got the same errors. The issue seems to be just the password protection on the database. I tried another db without a password and connected right away. Any other thoughts? Again I do appreciate the etiquette education and your efforts to assist me.

You might want to try the approach suggested in this article: http://support.microsoft.com/kb/208933. Although it's for Access, the principles should be the same for other databases too.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]