Mail Merge not sending emails through Outlook using Access Data Table

Hi @Stewart, Triton

Thank you for reaching out to the Microsoft Q&A forum. 

Based on your description, the issue may be caused by the email field name not matching correctly between Access and Word. Please double-check the field name and also ensure the account you’re signed into in Word is the same as in Outlook. 

I tested this in my Microsoft 365 environment and the mail merge worked successfully. Here are the steps I followed, and you might try them on your side to see if they help with the issue. 

-In Access:  

+Create or open table  

+Go to External Data > Word Merge 

+Choose whether you want the wizard to link your address data into an existing Word document, or to start with a new, blank document.

-In Word:  

+Select document type: E-mail messages 

+When finishing, choose Finish & Merge > Send E-mail Messages. 

+In the To: field, make sure it is mapped to your email column.  

You can refer this article for more details: Use mail merge to send Access data to Word - Microsoft Support

If the issue persists, please share more details and a screenshot (with personal information hidden) so we can look further into it. Since you mentioned you have been following the instructions online, could you also share the link you used so I can review it too? This will help me understand exactly what steps you’ve taken. 

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution. 

I'm looking forward to your response.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

If the cause of your problem is that New Outlook has been installed on your system, you can of course change the Windows default email client as Karl mentions in the article to which Duane gave you a link. Like him I've always used Thunderbird. For examples of Access to Word automation you might like to take a look at AccWord.zip in my Dropbox public databases folder at: 

https://www.dropbox.com/scl/fo/0scigd3r48hx5xrev2jrf/AB0-GMdTgMAO5O1cGdr3QW0?rlkey=ib6bs6g9jqcrywwzivur3265t&dl=0 

This little demo file includes a number of examples for undertaking a Word mail merge from within Access.  These do not reference an Access table or query directly as the data source for the merge, but create a text file from an Access query, and use the text file as the source for the merge.

PS: An alternative approach, which might or might not be appropriate in your case, would be to email an Access report as an attachment. The InvoicePDF demo in the same Dropbox folder to which I gave you a link includes examples for emailing multiple reports, invoices in the example, to customers. If multiple invoices are selected to be sent to multiple customers, a single email is sent to each customer, each with the invoices to that customer as an attachment.

We were using the new outlook. We switched to old outlook and it worked!

Thank you!