Copy excel table into outlook

[sanjay21051990 (sanjay shankhla)]

Hi All,

Below the Solution i have used from converting the ps1 script to vb.net script

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…

However as mentioned by @Lipika_Porey there are many ways to achieve this

Attached the below vb.net script for you Reference

email_part.zip (103.1 KB)

Regards
Sanjay

[sanjay21051990 (sanjay shankhla)]

Hi,

Below using SMTP,

Using_SMTP.xaml (13.4 KB)

Regards
Sanjay