Using Data from Excel – Part II

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:

Screenshot of The Job After Part I

Now, we need to send a different email for every row that is contained in the data table.…

Using Data from Excel – Part I

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!

The first thing that we need, is an Excel file that contains the information that will be used to send the emails.…

WinAutomation Features – The Ping Trigger

One of the most frequently used triggers in WinAutomation is, without a doubt, the “Ping Trigger”. To sum up its functionality in two sentences, we could say that: “the ping trigger will ‘ping’ a host (usually an IP address or a URL) at the interval you set. If the host does not respond within the timeout you set, this registers as a failed ping attempt, and triggers the Job.” (this is actually the main description of the trigger in WinAutomation’s Help File).

However, in some cases it is hard to understand exactly how the Ping trigger works and how you can put it in use in terms of web automation.…

Copyright 2017 - Softomotive Ltd