To Extract Message

[Mathew]

I want to extract the message from a particular person with particular subject line in excel. How to automate that?

[forumsupport]

Hello,

Automation Anywhere Client Integration Pack provides ‘Email Automation’ commands to manage all your incoming emails and download them to specific folders. You can also clear unwanted mails and automatically communicate with your mail server thereby effectively monitoring your emails.

You can use ‘Get All Messages’ Email Automation command to loop through all the emails on specified email server. Inside loop you can check if email is from particulay email address and the subject includes the particular line then save that message into excel. You can use system variables $Email From$ , $Email Subject$ and "$Email Message$ to get the from email id, subject and message respectively.

1 Excel : Open Spreadsheet "C:\Book1.xls". Active Sheet: Default
2 Start Loop "Each message on server: mail.tethyssolutions.com, User name: support@tethyssolutions.com"
3 If $Email From$ Includes "Tethys" Then
4 If $Email Subject$ Includes "Keyword" Then
5 Excel : Set value of Active Cell with "$Email Message$"
6 Excel : Go to one cell below the active cell
7 End If
8 End If
9 End Loop

Hope that helps.