Questions tagged [mail-merge]

Use for questions about combining a structured data source with a template to achieve automatically some appearance of customisation such as when generating many copies of the same body of a letter with different addresses.

Filter by
Sorted by
Tagged with
0
votes
1answer
22 views

Mail merge BUT body is like address label merge (multiple spreadsheet rows per output) while header and end act like regular mail merge (1 row per...)

The header and end of the template need to operate like mail merge, one set of data per document, while the central body of the template needs to operate like address-label-mail-merge, one row per ...
1
vote
0answers
16 views

Google Sheet merge using source code

I am using the below source code which I'm happy with however there are a couple of things I would like to tweak to make my life a little easier. For the final merged docs I'm wanting to know: how ...
1
vote
1answer
120 views

How can I insert formatted links in Google Sheet concatenations?

I am using Google Sheets to run mail merges using the script editor; it references a cell with an email address and a cell with the body of the email. I am able to concatenate a number of other ...
3
votes
1answer
3k views

How should I automate graph generation and image output in Google Sheets?

I am trying to send graphs of data to email recipients. I would like to output images of row-specific graphs based on cells in a Google Sheets document. In combination with Google Sheets/Drive, I am ...
0
votes
1answer
5k views

Insert Google Drawings into Gmail body

I am using Yet Another Mail Merge with Google Spreadsheets and Gmail and it works just as expected. But I am also trying to add a Google Drawings into the email body, so I would have more flexibility ...
1
vote
0answers
638 views

Yet Another Mail Merge - sending to multiple recipients

I'm required to send a parametrized mail message to multiple recipients, based on values in a Google spreadsheet. I've followed the instructions in this guide on how to use Yet Another Mail Merge. ...
2
votes
1answer
381 views

How can I personalize HTML emails using Mail Merge and Google Spreadsheets?

I'm attempting to personalize an email that uses HTML coding. Basically, I've made an HTML template that I want to have say the name of a person within the HTML code as well as the subject line of the ...
1
vote
1answer
5k views

Mail merge from Google Sheets to a Google Docs [duplicate]

I want to print out tests for a class I teach, but I want each to be identical except for the name of the student at the top. I want this to be drawn from a Google spreadsheet that I've created that ...