Contact multiple emails from Table + Adding unique Fields for each email

[Youssik]

Hi Everyone,

I'm new to Caspio and I'm trying to figure out how to set an automated email system, with a manually updated table every day.

So, I have a table that contains 4 columns : Contact Name, Contact Email, Order ID, Item Name.

The mail template will contain in it's body 3 of the parameters ( Contact Name, Order ID, Item Name ) and should be sent to the list of emails from the table. 

Can anyone help me with this task ?

Thank you in advance

[Mathilda]

On 11/11/2017 at 10:42 AM, Youssik said:

Hi Everyone,

I'm new to Caspio and I'm trying to figure out how to set an automated email system, with a manually updated table every day.

So, I have a table that contains 4 columns : Contact Name, Contact Email, Order ID, Item Name.

The mail template will contain in it's body 3 of the parameters ( Contact Name, Order ID, Item Name ) and should be sent to the list of emails from the table. 

Can anyone help me with this task ?

Thank you in advance

Hi,

This should be possible with zapier (e.g.:connection with mailchimp) or you may utilize caspio notification email.

You should update all the records to run an email on update. Add a test field and update a field using bulk edit feature on report

Hope that helps.

[Youssik]

Hi Mathilda,

Thank you for your advice.

I'm trying to figure out how to use zapier and mailchimp.

But can you recommend a link or a guide on how to utilize caspio notification email ?
I tried to find a way with a test table, but didn't receive any of the email notifications.

Thanks in advance.

[BaySunshine]

Hi Youssik,

Following is a video on how to integrate Zapier with MailChimp. 

https://www.youtube.com/watch?v=fPUJFy4VElg&feature=youtu.be

Also, here is the Caspio link on Zapier:

https://howto.caspio.com/integration/zapier/

Hope this helps.

 

[Kurumi]

Hi @Youssik,

Just an update. You may also use the new feature TASK on this certain scenario. This allows you to update data and send emails based on a predefined time schedule which you can use to your workflow. 

To know more about Tasks, check it here:  https://howto.caspio.com/tasks/

Check this video for more information

I hope it helps!