0

I am trying to use Word mail merge to send emails and retrieve all the data like name and title from an Access database however, the database is password protected and I keep on getting errors saying the password is wrong even though it is the correct password.

I have searched all over the internet and nothing seems to be working. In addition, I have tried allowing exclusive access when making the connection and have tried different connection types and nothing is working.

Oscar Sun
  • 1,427
  • 2
  • 8
  • 13
Adam Khattab
  • 111
  • 7
  • 1
    Review https://answers.microsoft.com/en-us/msoffice/forum/all/mail-merge-on-a-password-protected-access-database/c2bfe4ec-ea6c-4287-9249-37a060e9d731 and https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-automate-word-mail-merge-with-password/7250800e-0ffb-4ff3-ab8a-4ce8ef655a11 – June7 Apr 24 '23 at 18:21
  • Thanks, it worked. Please can you add it as a response so I can give it a green tick. – Adam Khattab Apr 29 '23 at 21:31
  • Exactly what worked? You can post an answer and accept it. – June7 Apr 30 '23 at 02:33
  • But then you won't get the reputation you deserve. – Adam Khattab Apr 30 '23 at 09:53
  • Not a concern for me. Not really interested in making effort to build and verify code. You can simply post your working code in an answer. – June7 Apr 30 '23 at 15:54

1 Answers1

1

The answer is in this forum: https://answers.microsoft.com/en-us/msoffice/forum/all/mail-merge-on-a-password-protected-access-database/c2bfe4ec-ea6c-4287-9249-37a060e9d731

a. in Word, go to File->Options->Advanced->General (near the bottom of the Advanced options)

b. check "Confirm file format conversion on Open"

c. re-open your Word Mail Merge Main Document

d. go through the process of connecting to the Access database again (e.g. Mailings tab->Select Recipients->Use Existing List

e. Once you have selected the .mdb or .accdb, you should see an additional dialog box titled "Confirm Data Source". For an ACCDB, only one option will be displayed ("OLE DB Database Files"). In that case, check "Show All". A number of other options should appear.

f. locate and select the option titled "MS Access Databases via DDE (.mdb;.mde)", then click OK.

g. If the database is already open in Access, you should now see a dialogue box with a list of tables/queries. Otherwise, Word tries to start Access if it is not already running, then asks Access to open the database. At this point, Access should prompt you for the database password. However, it is possible that the dialogue box will appear behind Word, so if you do not see it quickly, alt-tab to the Access application and respond to the dialogue box. Then you should see the list of tables/queries and you can proceed.

Jesse
  • 1,386
  • 3
  • 9
  • 23
Adam Khattab
  • 111
  • 7