How can I send automatic emails according to date indicated on my spreadsheet?

1. Add the dates on your spreadsheet

2. Insert a column with a formula. In the case below we want to bring up OK if the date is today. The formula will therefore be 

=if(month(E2)=month(today()),if (day(E2)=day(today()),"OK","no"),"no")

 

Screen_Shot_2017-04-27_at_2_58_29_pm.png

 

3. Set your filters from the settings menu

Screen_Shot_2017-04-27_at_2_59_48_pm.png

 

4. Choose when to generate your Mail Merge

Screen_Shot_2017-04-27_at_3_19_33_pm.png

 

Screen_Shot_2017-04-27_at_3.11.19_pm.png

 

Your Mail Merge will then be generated according to the filters you have set and time set up

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk