How to copy paste a table from Excel sheet to outlook mail

0
votes

I have a dynamic table in sheet2 of my Excel sheet. How to copy this entire table from sheet2 to outlook mail body using Outlook VBA.

3
excelvbaoutlook
Can you share an example spreadsheet? – 0m3r

3 Answers

2
votes

The below steps you have to follow,

      Copy the tables into Microsoft word application
      Now Copy the tables from Microsoft word application
      Now Past the copied tables from Microsoft word application to your Email

This will work perfectly, let me know via comments if you are still facing the issue.

0
votes
  1. Select First Cell of your table, means first header cell
  2. Press Ctrl+A
  3. Press Ctrl+C
  4. Switch to Outlook
  5. Place the Cursor in your Email Body where you want table
  6. Press Ctrl+V
-1
votes

(1) Ctrl+A in your excel then (2) Ctrl+C and (3) Ctrl+V in outlook