WinAutomation - windows automation software with macro recorder
About Softomotive

      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:





      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!





      How To - Modify the "Date Created" and "Date Modified" attributes of files

      A couple of weeks ago, we have received the following support request from a WinAutomation user:

      "How can I change a file's modified date? I figured out how to get the modified date but can't figure out how to change it. Essentially I have a TIF and JPG file and I want to make the JPG have the same modified date as the TIF file."





      Logical Operations in WinAutomation

      Sometimes when you are creating a conditional, you may want to check if 2 conditions are simultaneously TRUE (or FALSE ). Some other times, you may want to execute a block of actions if at least one of the 2 conditions is true. WinAutomation allows you to perform basic logical operations with boolean variables. The logical connectives that are available in WinAutomation are the following:

      Negation (not): !
      Conjunction (and): &&
      Disjunction (or): ||





      Send Multiple Repetitive Keystrokes with Send Keys

      When automating form submissions with WinAutomation, it is usually needed to send the same keystroke multiple times. A typical example is the {Tab} keystroke which is used to change the input field that we are currently editing. For example, in the form that is shown below:


      you will have to send 11 Tab keystrokes in order to modify the "Distance from ground".






      Featured Clients




      Monthly Blog Archive