Paste Excel table into Outlook message

DIrk Devos

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

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.


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.


New Member
Outlook version
Outlook 2013 64 bit
Email Account
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.



New Member
Outlook version
Outlook 2013 64 bit
Email Account (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:
Thread starter Similar threads Forum Replies Date
N Paste content to Excel when .txt file (attachment) is opened Outlook VBA and Custom Forms 1
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
C Copy Cell value from Excel and paste into current email Outlook VBA and Custom Forms 10
F Cut and Paste Addresses from Excel Suddenly Limited Using Outlook 4
P Add Paste Unformatted to QAT Using Outlook 1
B Paste formatted text (bold, underlined and in quotes) Outlook VBA and Custom Forms 1
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
O Macro - paste as plain text Outlook VBA and Custom Forms 2
O How to paste website content using a specific font and removing URLs Using Outlook 2
D Outlook macro with today's date in subject and paste clipboard in body Outlook VBA and Custom Forms 1
K Paste from Windows Clipboard then change font without losing formatting Outlook VBA and Custom Forms 1
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
Diane Poremsky Paste clipboard contents using VBA New Articles 0
A Outlook: copy & paste Outlook VBA and Custom Forms 9
V Copy and paste body and subject and send multiple emails Outlook VBA and Custom Forms 3
G outlook 13 copy & paste without losing formatting Using Outlook 1
R Copy/paste mailing address Outlook 2013 Using Outlook 6
D Open attached CSV, copy newdata and paste it to database CSV Outlook VBA and Custom Forms 2
O Copy email content and paste into new Word Document using a different font Using Outlook 1
makinmyway Research Pane in Emails Turns on and Cut Paste Keys then Stop Working Using Outlook 5
L Outlook 2007 Delete and Paste Between Fields Using Outlook 25
L "sometimes" cant send mail, we have to copy and paste the message and resend? Using Outlook 2
I Clipboard paste in macro Using Outlook 14
N Cut and Paste Taking 25 seconds Using Outlook 0
S I'm not able to copy and paste on outlook. Using Outlook 1
M Outlook 2007 Copy-Paste problems Using Outlook 6
L Hyperlins within Outlook will not work, I have to cut and paste to internet explorer, how can this be fixed Using Outlook 1
F I cannot highlight text in Microsoft Outlook 2010 e-mails, and copy/paste to the body of another e-m Using Outlook 3
J cannot copy and paste while in list view in-cell editing Using Outlook 1
N Cannot paste image in the body of an email, it will only attach it as a file. Using Outlook 4
J How to copy and paste in Outlook 2010 ? Using Outlook 3
S Copy/Paste from Office Word 2003 to Outlook 2003 Using Outlook 3
R copying or cutting an appointment to paste it to a different date Using Outlook 1
J OWA copy/paste and drag/drop Question Exchange Server Administration 2
J asking again, why am I getting weird thing when I want to paste in email? Using Outlook 6
D Problem with Microsoft Office 2010 Clipboard (Copy and Paste) Using Outlook 1
O How do I copy and paste calendar dates in 2010 outlook? Using Outlook 1
I Office 2003 Crashes when trying to Copy, Paste, or Save with Windows 7 Professional Using Outlook 4
S Outlook 2010 Very slow paste. Using Outlook 2
R how to copy a list of email contacts and paste them only as names (not names + email address) Using Outlook 12
B Paste Shortcut to an Outlook Item Using Outlook 1
B Every time I paste into an email Outlook locks up Using Outlook 1
C Copy Paste Using Outlook 2
N Outlook 2007 - Attachment Copy/Paste issue Using Outlook 1
N User is trying to COPY and PASTE text document in outlook. But the output of copied text is an image. Using Outlook 5
H outlook 2003 all folder except sent folder if copy paste message its comes in today date.but in sent folder its create duplicate entry. i want same li Using Outlook 0
J Copy/paste in outlook & pasted text is in html Using Outlook 17
R My outlook calendar has lost the cut and paste ability Using Outlook 21
Similar threads