ODBC / Word Mail Merge

[Sashman]

Hi.

What is the best way to export AirTable data for use in Microsoft Word’s Mail Merge tool, and have it updated in Word after making changes in AirTable?

[Howie]

For now, we’d recommend exporting to CSV: https://support.airtable.com/hc/en-us/articles/202624339-Exporting-records-in-a-view-to-CSV

As an alternative to MS Word, you may want to explore some of the following options:
https://www.webmerge.me/airtable-document-generation

Airtable - Support

Using Zapier to integrate Airtable with other apps and services

Zapier is a third-party service that connects Airtable to many other apps and services, including Slack, Twitter, Gmail, MailChimp, Github and more. This article is specifically designed to teach y...

[egordin]

+1 vote for this, as we need to use Microsoft Word’s Mail Merge as well.

If we cannot connect directly to Microsoft Word, can you at least make it possible to get an automatic CSV download (maybe via Zapier → Dropbox integration), so that then Microsoft Word can automatically read from the updated file?

[Greg_Witkamp]

I would setup an excel file to query to the data from Airtable that will be used for the mail merge. This would give you a quick controlled way to refresh your list. Skip Zapier all together.

Here’s a thread that goes through the details of setting up power query to bring in your Airtable data
https://community.airtable.com/t/airtable-link-to-excel-via-power-query/18675

[ScottWorld]

The best, easiest, quickesst, and cheapest way to automate & integrate Airtable with Microsoft Word is to use Make's Microsoft Word Merge functions for Airtable.