Issues Using Word Document as the Body of an Email

[agandolfo22 (Andrew Gandolfo)]

Hello All,

I’m having an issue when using the contents of a Word Document as the body of an email that is composed as a draft by my automation.

While the text of the Word Document smoothly converts to the email body, the table that is copied and pasted from Excel into the Word Document by my automation is not captured in the email body.

Has anyone encountered this?

[Thanu_Matheesha1 (Thanu Matheesha)]

If you want to use the table in the email body you have to use HTML tags. I think in your case your table values are pasting as a raw string right?

[pravin_calvin (pravin kumar)]

Hi @agandolfo22

Welcome to community!

Have you selected the type as word in send email in studio-X

Regards

[Shikhar_Tandon]

Hi @agandolfo22,

Have a look on the below thread if that can help you

How to write the contents of excel into email message body without loosing table formats

Hi folks, I have a requirement where I need to read the data from excel and send that content in a email. How can I achieve this without loosing the table structures. Can somebody please help me on this. Read the excel file and stored in datatable output Used output datatable activity and stored the output into string variable Used this string varaible into email message body but I see the format of the table will go with this approach. Thanks, Vishal Kumar

Thanks

[agandolfo22 (Andrew Gandolfo)]

Thank you all!

I think I may have figured it out.

@pravin kumar: I did, in fact do what you indicated. What I realized was I hadn’t cleared the original values I had in the email body when originally selected “Text” in the Send Email activity.

When I cleared those values and selected to populate the email body from the “Document”, the table pasted into the email as desired.