Gmail Mail Merge

[Michael Huertas]

Anyone has an idea if it's possible to set an interval time for the email being sent using the Gmail/Sheet Mail Merge? Does this have to do with the script? A snippet i can insert on a part?

Please let me know if it's possible. Would appreciate someone who'd answer. All the best!

[Martin Hawksey]

Hi Michael,

When you say 'interval' do you mean while the script is running? If so, you can temporarily pause a script by adding Utilities.sleep(1000); This will pause the script for a 1000 milliseconds (you can increase it if needed). 

If you are using the mail merge solution from the developer documentation the code can be added after out.push([new Date()]);

Hope that helps

Martin

On Thu, 3 Feb 2022, 02:29 Michael Huertas, <michael...@forcs.com> wrote:

Anyone has an idea if it's possible to set an interval time for the email being sent using the Gmail/Sheet Mail Merge? Does this have to do with the script? A snippet i can insert on a part?

Please let me know if it's possible. Would appreciate someone who'd answer. All the best!

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/eebc143e-2501-4d35-ba6d-48bbdddf16a0n%40googlegroups.com.

[Michael Huertas]

Hi Martin,

Works perfectly! Appreciate the help bro! 

All the Best!

Mike

[Ram Kiami]

Hi Michael,

I am looking for a mail merge script and really appreciate it if you happen to have one that could be shared. 

Sorry if this causes any inconvenience. 

Many thanks,

Ram

[Martin Hawksey]

Hi Ram - there is a mail merge example published on the Google Developers site https://developers.google.com/apps-script/samples/automations/mail-merge