How can I easily customize my email subject lines using the Mail Merge function?

Map the Email Subject to a header column in your spreadsheet (1).

Add the common data in the cells below and use the formula below (2) to pull in custom data from another cell in your spreadsheet. Copy and paste your formula to all cells where you wish generate a Mail Merge. 

In the case below the formula we will use is

="Training program for "&A2

 

Screen_Shot_2017-04-05_at_10_31_39_am.png

 

NB: Only copy formulas to cells where you wish to generate a doc and/or mail merge as the add-on will run on every cell where data is detected. 

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk