Get Email Body Details in Excel cell Rows

Help
, , , ,
1

Hi Friends,

I have a requirement as outlook data will have to capture in excel as rows.
is it possible to create a flowchart ?

Please suggest me how to create the list of functions will have to use?

Best Regards,
Ramana

2

Hi @Raman2,

Please see the attached screen to get outlook mail messages.

OutlookMail

Thanks,
AK

1 Like
3

Hi
welcome back to uipath community
thats absolutely possible
–hope these steps would help you resolve this
–use a BUILD DATATABLE ACTIVITY with which create a datatable with one column named Mailcontent of type string and get thet output with variable of type datatable named Finaldt
–followed by this use CLEAR DATATABLE ACTIVITY and mention theinput as Finaldt
–use GET OUTLOOK MAIL ACTIVITY and get the output with a variable of type list of mail message named list_mails
–now use a FOR EACH activity and pass the variable list_mails as input
and change the type argument as system.net.mail.mailmessage in the property panel
–now use a ADD DATAROW activity and mention like this
{item.Body.ToString} in the arrayrow property and datatable property as Finaldt

–so next to this FOR EACH LOOP use a EXCEL APPLICATION SCOPE and pass the file path of excel as input and use WRITE RANGE activity and mention the input as Finaldt and enable add headers property

Cheers @Raman2

4

Thanks anand

Have a great day

1 Like
5

Thanks palaniyappan

Have a great day.

1 Like
6

Cheers @Raman2

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.