Paste Excel table into Outlook message

DIrk Devos

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi,

I have learned VBA using Excel where there is a recording feature that I could use to get an idea where and what to look for but that is not available in Outlook making it difficult to get a starting point so I would appreciate some help.

I have a range selected in Excel and I would like to paste it into an Outlook HTML email body as a table. When pasting the data I need to use the destination styles option. After pasting I want to select the table and apply "autofit to contents" and change the font size.

My ultimate goal is to run my Excel VBA code to isolate the range of data that I need and then open a new Outlook message and create a status report that includes the table.

Any help pointing me in the right direction would be appreciated.

Thanks.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
That exact table using VBA? No... but you can select it and copy/paste.
 

mike88

New Member
Outlook version
Outlook 2013 64 bit
Email Account
POP3
is it possible to copy and paste with same format property? :)
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Yes. After you paste the click on the paste button and click the Keep source formatting button.

2752
 

elena747

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Outlook.com (as MS Exchange)
You should be able to just copy and paste the code... have you tried that? I will give it a try on my own and will come back here with an update :rolleyes:
 
Top