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

[Lipika_Porey]

You can also try the below method to paste excel data in outlook mail body.

Urgent Help Required in Pasting excel table in outlook body

Hi @Mukul_Chandravanshi I have used shell scripting to copy and paste excel data in outlook body. This preserves the format as well. Steps to replicate the process is as follows:- Step 1 - Open a notepad and paste the below code and save the file with .ps1 extension $x1 = New-Object -comobject Excel.Application $UserWorkBook = $x1.Workbooks.Open(" excel path") $UserWorksheet = $UserWorkBook.Worksheets.Item(1) $UserWorksheet.activate() $rgeSource=$UserWorksheet.range(“A1”,“D11”) $rgeSour…