Email body to excel

I have an email that comes in where a chart from excel has been copied and pasted to the email body. How can I grab the chart and place it back in excel.

@seanp92

How to write email body table to excel file?

Try the way as mentioned in the link.

Fine
—usually those images or charts will be a embedded one along the mail
—so use GET OUTLOOK MAIL ACTIVITY and get the output with a variable of type list of mailmessages named list_mails
—now use a FOR EACH loop where pass the list_mails as input and change the type argument in the property panel of for each loop as System.Net.Mail.Mailmessage
—and inside that loop use IF condition like this
item.Attachments.Any
If true it will get into THEN Part where we can use SAVE ATTACHMENT activity and mention the file path along with the file name and mail Input as item

This will save the image or that chart to a folder
Now we can use some set of custom activities to insert image to a excel

Kindly try this and let know for any queries or clarification
Cheers @seanp92

1 Like