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
0 answers
26 views

How do you create name badges in Google Docs with a background, preferably using Avery?

I am trying to use Google Docs to create name badges that have a background image behind the text. Our company used to have Microsoft Suite and historically, we used the Mail Merge option within the ...
user avatar
0 votes
1 answer
29 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 ...
user avatar
1 vote
0 answers
20 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 ...
user avatar
  • 11
1 vote
1 answer
136 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 ...
user avatar
  • 513
3 votes
1 answer
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 ...
user avatar
  • 513
0 votes
1 answer
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 ...
user avatar
1 vote
0 answers
641 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. ...
user avatar
2 votes
1 answer
398 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 ...
user avatar
1 vote
1 answer
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 ...
user avatar