How to send the table from the excel in outlook mail body?

[naveen.s]

Hi All,

I want to send a mail using outlook.
How can I write the table in the body of the mail i.e. I need to copy the table from the excel and I need to paste that inside the body mail.

and I need to header to coloured in Green colour.

Can someone please help me on this??

If you wanna share the code please do not share zip file because in my organization we cannot download the zip files.

Thanks in advance.
EmployeeDetails.xlsx (13.1 KB)

[anilkupatnaik (Anil Kumar Patnaik)]

HI @naveen.s

Check the below thread:

How to send dynamic and multiple table in email body

Hi @satish.rathi59 You can use Create HTML content activity to create the body and insert table and save the output in a Variable. Pass this output in Body field in Send outlook mail message or Send SMTP activity and check the IsBodyHTML option in properties. → Use the Read Range workbook activity to read the excel and store in a datatable variable. → Click on the Open editor option in Create HTML content activity a window popsup. → In that window, click Add data values, and click on Add …

Regards

[Sai_chnadrika_Kopparapu (Sai chandrika Kopparapu)]

Hi @naveen.s

Please find the below workflow:
Sequence.xaml (9.6 KB)

Hope it helps!!

[Sai_chnadrika_Kopparapu (Sai chandrika Kopparapu)]

Hi @naveen.s

Required Output:

Regards
Chandrika

[naveen.s]

@Sai_chnadrika_Kopparapu ,

Please send the photo of the solution since I am not able to open your code

[anilkupatnaik (Anil Kumar Patnaik)]

Have you gone through the thread I have provided? @naveen.s

In that thread there is step by step process for achieving your requirement.

Regards

[naveen.s]

@anilkupatnaik ,

Yes I did but the output is not perfect the headers are not coming.

[anilkupatnaik (Anil Kumar Patnaik)]

HI @naveen.s

Uncheck the option add headers from the read range workbook activity and it works!!

Regards