Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Re: ODBC / Word Mail Merge

114 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

3 Replies 3

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

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...

+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?

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