Are there any plans to implement native mail merge & envelope functionality into Google Docs? We use Google Docs for everything except for postal mailings, where we use Word. I would like it if we could use Google Docs for absolutely everything, and if you added mail merge functionality, then you would have a leg up on Microsoft Word - another reason that Google Docs can be a great replacement.
Thank you
Solved! Go to Solution.
Hi sweber,
You can use the AutoCrat extension to do this. You can have a Google Sheets document and use values from there to generate documents once you have a template. Here's the marketplace extension: https://workspace.google.com/marketplace/app/autocrat/539341275670
Enjoy the rest of your week!
- JohnP
This is already possible with a simple app script. Here is the link to the article that walks you through the process. https://developers.google.com/docs/api/samples/mail-merge
Hi sweber,
You can use the AutoCrat extension to do this. You can have a Google Sheets document and use values from there to generate documents once you have a template. Here's the marketplace extension: https://workspace.google.com/marketplace/app/autocrat/539341275670
Enjoy the rest of your week!
- JohnP
+1 for AutoCrat; we use it for mailings, certificates, onboarding docs & more.
I'll check Autocrat out - I was thinking more of it being a native feature, rather than a third-party addon.
Have google announced if they will be making a native mail merge system?
the above options are really suitable for my company
You might want to have a look in the NDAed product roadmaps to see if there’s anything there about this. See
https://www.googlecloudcommunity.com/gc/custom/page/page-id/Workspace-Roadmap-FAQ
for how to request access.
Hope that helps,
Ian
Yes. Google has introduced Multi-Send mode and Design Layouts for branded emails last year in July. It gives you mail merge and simple email template design editor.
Here is the original announcement:
https://workspaceupdates.googleblog.com/2022/07/new-integrated-marketing-tools-for-gmail.html
And here are help articles for both features:
https://support.google.com/mail/answer/11243118?hl=en
and
https://support.google.com/mail/answer/10960345?hl=en
I meant for Postal Mail.
Given how online focused Google is, I wouldn’t count on there ever being a native feature for that. Perhaps there’s an add-on available that will do this? Doing a Google web search for “google docs mail merge envelope add on” turns up what appears to be several possibilities.
Yeah I figured, but thought I'd put the idea out there since Microsoft Word (Desktop) is really the only big player that offers classical mail merge. We still do mailings from time to time here. 🙂
Autocrat is pretty good, but has its quirks and I don't like how the jobs are stored in the Spreadsheet and not the Document (opposite of how Word works). The data spreadsheets are always different documents; copying and pasting from another is tedious.