Dear Forum Members,
I have designed a workflow where I am extracting email data into an excel file. I am able to extract Date, subject, Email ID of sender etc. But for the email body, I am facing an issue. If email body contains plain text, then I am able to extract email body but if it has links, table etc. then I am getting the email body as html tags. I am using “mail.Body.ToString” for extracting email body. How can I extract the data as it appears in the email.
One more issue I am facing is: If email body has large text i.e. number of characters that excel cell can’t hold then it is automatically splitting the text and write the text in other line(after 4,5 lines) and because of it, the extracted data is not in correct format i.e. it is not able to write the data properly which is of no use. So, how can I resolve this issue.
I am using Send SMTP Mail Message.
Please help with both the issues, Thanks in advance.