Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Emailing with Access and Mail Merge

Copper Contributor

I am a new user of Access 365.  I have created a personalized letter to send to multiple email recipients in an Access database.  I complete all the steps, but after clicking the OK in the last step, nothing happens.  I don't know if my email is connected to Access.  Does it need to be?  Thanks.

2 Replies
In which application did you create your letter?
How exactly are you trying to send your email?
You complete which steps exactly? Please give us a step by step explanation so we can follow along.

@Daniel_Pineault 

 

I am new and not very savy but I will try to explain. I appreciate any help you can give me. 

 

I am using Access.

 

Here are the steps I followed. I opened the database and selected the appropriate query. I opened External Data and Word Merge.  I selected Create a new document and link data to it. I selected email message as the document type. I selected Use current document, then Select Recipients, then Use existing list.  I then wrote the letter in Word and copied it into the window that opened in Access and selected “More Items” to add the names and addresses. I then clicked to Preview the letter, then selected Complete your Merge.  Under that I clicked on Electronic Mail. I entered the message subject and selected HTML and Send Records to All.  When I clicked on OK, nothing happened.  No email was sent.

 

As background information, let me explain that someone else created the database which I transferred to my computer.  We both have access to the association’s email address.  But he has Microsoft Outlook as his email and I use AOL.  The shared email address is a gmail account. 

 

I don’t know if I have to have Outlook to use Access. 

 

I figured I must have to connect the Access database to my email.  But, if that is the case, I don’t know how to do that.

 

Please let me know if this answers your questions. .

 

Cynthia