<div>
Word's Mail Merge can use an Access &nbsp;query as a datasource. There are some restrictions. It can't be one-to-many or use parameters.<br />
<br />
If the Sql doesn't have to change between runs, then you can set up a merge that will run without coding. It will use your default mail application (Outlook if that is what you use). &nbsp;You can set it up and run it from Access via the Word Merge button on the External Data tab<br />
<br />
I
</div>


Word's Mail Merge can use an Access  query as a datasource. There are some restrictions. It can't be one-to-many or use parameters.

If the Sql doesn't have to change between runs, then you can set up a merge that will run without coding. It will use your default mail application (Outlook if that is what you use).  You can set it up and run it from Access via the Word Merge button on the External Data tab

I

<div>
poster disappeared - solution works
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
How can I use an Access 2016 query to send mail merged emails via Outlook 2016?<br />
<br />
Regards,<br />
Leigh
</div>
</div>


Hi Experts,

How can I use an Access 2016 query to send mail merged emails via Outlook 2016?

Regards,
Leigh

Use an Access 2016 query to send mail merged emails via Outlook 2016

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.