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.
10
questions
0
votes
0
answers
59
views
Creating Multiple PDF's from Google Sheets from a client list
I have a Google Sheets spreadsheet with logged times for projects. I need the data from each client to create a PDF with their times displayed. See attached image. This example has four clients, so I ...
- 9
0
votes
0
answers
186
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 ...
wiggly
0
votes
1
answer
46
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
0
answers
25
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 ...
- 11
1
vote
1
answer
141
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 ...
- 533
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 ...
- 533
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 ...
- 101
1
vote
0
answers
643
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.
...
- 11
2
votes
1
answer
424
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 ...
- 21
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 ...
- 11