Posted at by Samantha under: trigger jobs on email reception retrieve information from email for random usage

PART III. Automating email replies and auto forwarding specific information from email's body to other emails (Receiving an order via email, sent from my business website order form. Sending the information found in the email's body to my Sales department to process the order, Sending email to the customer to thank him for purchasing the products)


You are the one that has to receive all the emails, extract information from each one of them and send different parts of the information contained in the email to different recipients.. Well... That's easy now with WinAutomation!

(Please note that in order to get this job to work you need to have Thunderbird and Autoextract running and also created the job described in the INTRO part of this Topic)

INTRO. Using the FileMonitorTrigger in combination with Thunderbird to start jobs according to emails received based on subject, email, email body etc.


This job is more less the same with Part I and II, we get the files downloaded to the specified system folder using Thunderbird, and we use the Parse text action to retrieve the Information we want using regular expressions.

Using the Send Email Action

Once we have finished parsing the information and stored them individualy into variables, we then get the Send Email Action and we start typing our email.

We also need to specify our email settings so that WinAutomation can send the emails each time this job runs without having to ask us to provide the login information and the server connection details.

As you can see, you can send the value that is kept within the variable in the emails body and when the recipient receives the email, they will not see the variable name, but the actual value it contains.

So a text such:

Subject: ORDER ID: %MatchOrderId%

Id: %MatchCustomerId%

Product_Id: %MatchProductId%

Quantity: %MatchQuantity%

 

Would be delivered as:

Subject: ORDER ID: 1

Id: 001

Product_Id: AB123

Quantity: 30

 

Now you can send out as many emails as you wish to as many people you want retrieving their addresses from a list and use WinAutomation to create a more personalized for each recipient!

  


You can also check out and Parts I and II to get a clue about how jobs can connect one to the other.

PART I. Automating Registration Confirmation (Receiving emails from a website that requires confirmation of the user's email address, by prompting user to click on a confirmation link contained in the email to confirm details and registration)

PART II. Automating Data Entry from Email to Excel (Receiving emails from my business website where, customers sign up. Getting the customer's details from the email's body content and save the information to my customer's database which is in Excel)

Leave your comment

Copyright 2012 - Softomotive Ltd