Using Data from Excel - Part II

Posted on by Thomas Minitsios under: Excel Actions Loop Tutorial Data Table

In the first part of the "Using Data from Excel" blog post, we retrieved all the information from the Excel file and stored them in a data table variable called: %ExcelDataTable%. We also added a "Send Email" action that will send a single email to a specific recipient. In the second part of the blog post, we are going to create a Loop in order to send the email to every address in the xlsx file.

Our job should look like this so far:

Read more »

Using Data from Excel - Part I

Posted on by Thomas Minitsios under: Excel Actions Loop Read

After doing some research in our forum, I came across the same question multiple times: "How do I read all the information from an Excel file and then use it to send an email or fill a form?". I am writing this article to give you a step-by-step guide about how you can read all the information that are stored in an Excel worksheet, and use it to send customized emails to multiple recipients. So, let's get started!

Read more »

Copyright 2014 - Softomotive Ltd