Help

ODBC / Word Mail Merge

Topic Labels: Integrations
5842 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Sashman
6 - Interface Innovator
6 - Interface Innovator

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?

4 Replies 4
Howie
7 - App Architect
7 - App Architect

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

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.