Automate Copy and Paste from an EMS

Help Activities
, ,
1

Hi Experts,
I am trying to automate an Email management system(Ems) backup process , I will have a list of email under EMS and one by one email I have to click , and the email correspondence will open in another window under same screen , have to copy the whole content of email and paste in an excel one by one.

image001
image001731×658 9.04 KB

Any leads please ?.

Thank you.

2

Hi @yourspalani ,

Please try the below steps,

  • From the screenshot, it looks like emails have some names. Try to extract all the email names with the “Data scraping” in a datatable.
  • Loop through the datatable and use “click text” activity to click on the email names. (I am guessing this is the way to open emails).
  • Once mail is open at the bottom, use screen scraping to extract mail data in text.

Let me know if this works for you.

Regards,
Ashutosh Gupta

1 Like
3

Thank you @Ashutosh.Gupta for the assistance.
Actually I am trying your first two steps but struck at step 3 , When I click each email on top screen, I need point my cursor to bottom portion to click Ctrl + A ,because there is no fixed anchor in the bottom for me to click the area.
Is there any activity which can help to click some where in bottom area every time ?.

4

Have you tried “Screen scrapping”?

You can use Preview Emails as an anchor if required.

Cheers!

5

Thinking is there any way to right click one by one email from EMS and select ‘view using outlook’ then it has loop through all emails in that table and also it has navigate through other multiple pages.
For me it is only able to click first 10 emails in the first page , it is not detecting auto to move to next page and continue.

image