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 without registration, duration hours minute second in high quality. This video was added by user DoIT Training at Stony Brook University 08 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 812 once and liked it 4 people.