gmail merge with google sheets

[Rodney Fleming]

I see the Create a mail merge with Gmail & Google Sheets | Apps Script.   The tutorial has you copy an existing sheet that has the logic and script already integrated into the sheet.

How do I add this logic to a new sheet?     What are the steps to do this?

Thanks.

Rod

[Martin Hawksey]

Hi Rod,

If you want to add the script to another existing Google Sheet if you:

1.  open the copied mail merge example 
2.  Click Extensions > Apps Script which opens should open a script editor window. 
3. Select all the code in the script editor and 'copy'

Once you've done this open the destination Google Sheet and follow the same steps but use 'paste' rather than copy.

There isn't usually anything additionally you need to do for setup to get the script to work

Hope that helps

Martin