Google Sheets: Email Merge To Send Custom Attachments With a formula

Published: 08 July 2024
on channel: DoIT Training at Stony Brook University
812
4

Use vlookup to send quasi-custom attachments using mail merge.

If there's a column value you can use to find the right attachment from a list, this formula will help making mail merge emails even more customized and helpful.

More on vlookup: https://docs.google.com/presentation/...
More on email merge: https://docs.google.com/presentation/...

0:00 Intro
0:36 Have Docs/file links in sheet
0:50 Share docs/files
2:10 vlookup formula
5:48 Add {{Attachment}} to the draft

#googlesheets #googleappscript #gmail


Watch video Google Sheets: Email Merge To Send Custom Attachments With a formula online, duration hours minute second in high quality that is uploaded to the channel DoIT Training at Stony Brook University 08 July 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 812 times and liked it 4 visitors.