Oulook

Help Activities
,
1

Hello,

I am new to UiPath can anyone explain how to extract received time and date from recevier oulook mail to my local excel sheet. Thanks in advance.

2

Hi Welcome to UiPath Community @Swetha_V

1.Read outlook mails using get outlook mail messages that create one output variable to store the output assign that variable in output message property.
2.loop through each mail
3.in the body try like this item.Date so you will get date and time
4.so that will give date and time now update in excel

3

@Swetha_V

Use Get Outlook Mails activity->In Properties create a Output Variable

image
image1534Ă—619 31.8 KB

Place a Build Datatable activity, Click Datatable->You can define your columns, for example check as below

image
image855Ă—579 12.9 KB

After that step->Use For Each activity and give that variable->From Properties change the Type argument->Object to System.Net.Mail.MailMessage and for Index create another variable

image
image1562Ă—789 45.7 KB

Inside For each Row you can place a Assign activity and write as below

image
image936Ă—218 11.3 KB

Now use Write Range activity after For Each activity and give the Datatable as below

image
image675Ă—876 18.7 KB

For writing to Datatable, you can refer below

Hope this helps you

Thanks

4

Thanks for your reply…
Can i extract receiving time and date of different mailbox which is logged in through web in my system?

5

@Swetha_V

If you want to extract different mailbox date and time then you have to use get exchange mail messages activity.
-because get outlook mail messages activity will work what ever the outlook is configured in your system.

6

@Swetha_V

If you are using web instead of Outlook installed in your system, then you have rely on the selectors and Get Text activity, This is not a reliable solution when coming to Mail automation but you have to make sure that you have picked correct and reliable selectors

Hope this helps you

Thanks

1 Like
7

image
image574Ă—697 21.8 KB

Can you help me to fill these properties?

8

Dose it possible for a group of mails using Get Text activity?

9

@Swetha_V

That’s difficult because when mail activities will do mainly from background process, but some cases will go for web based, where it is not suggested, but you can check with the selectors, I’m not sure if this works, because selectors keep on changing

Hope this helps you

Thanks

10

Any update on this?

11

user: mailbox that you want to read(mailID)
password:password of that mailOD
Domain:your company domain name may be after @ in your email that can be your domain.
server:

Please go through Lesson - 11 Email automation topic under Level 1 Foundation Training in Academy.uipath.com

They explained all these things very well along with video. Go through first and if you have any doubts then let me know.

12

I am unable to find regarding server in Lesson 11 Email automation. Can you help me regarding it?

13

contact your IT team they will provide you the email server and ask exchange version

14

Thanks for your support

1 Like
15

Hello,
Can we extract both sent and received date and time from outlook mail at a time to the excel file?
Thanks in Advance…

16

Can anyone give explanation for above question…

17

@Swetha_V . Add another datatable column…and in the same loop add the sent date…

1 Like
18

Thanks for your reply… If you have any Workflow with you please send, that will be really helpful for me.

19

@Swetha_V - Please find the starter help here…Outlook_Received Time.zip (43.0 KB)

You can see from the below screen shot that, Mail.Header(“Date”) contains both date and time…

image
image1815Ă—677 58.4 KB

So In the add row activity I have used split function to split the date and time from the “Date” variable…

1 Like
20

Thank you…
Can i use same workflow to extract sent time and date to the same excel where i stored Received time and date. So that both sent and received data will be there in one excel only. Is that possible?