How to Copy and Paste an Excel Table into Outlook Email (3 Methods)

Method 1 – Copying and Pasting an Excel Table Directly from Clipboard Command

Steps:

• Select the table on your Excel spreadsheet.

• Press Ctrl+C.
• Open Outlook email and go to the section where you want to paste the table (main body of the email).

• Press Ctrl+V to paste the chart on the email client.

• You can also edit the table in the email client now if you want. For example, look at the value marked in the following figure and the previous one.

Read More: How to Mail Merge from Excel to Outlook with Attachments

Method 2 – Adding Excel Table as a Non-Editable Picture in Outlook Email

2.1 Copying a Chart as a Picture and Pasting into Outlook Email

Steps:

• Select the whole Excel table on the spreadsheet.

• Go to the Home tab on your ribbon first.
• Select the downward-facing arrow beside Copy in the Clipboard group section.
• Select Copy as Picture from the drop-down menu.

• Another box will appear. Select your preferred options here. In this case, we opt for As shown on screen as the Appearance option and Picture as the Format.

• Click on OK. Excel will now copy the table as a picture and store it on the clipboard.
• Paste the picture somewhere on the spreadsheet.

• Copy the picture with Ctrl+C.
• Paste it into the Outlook email client’s main body section by pressing Ctrl+V.

You can copy and paste the Excel table into Outlook email as a picture.

2.2 Copying the Snip of a Table

Steps:

• Open up the spreadsheet and press Win+Shift+S.
• Select the area you want over the table.

• Open the Snip & Sketch window (or the one you are using) and press Ctrl+C to copy the image on your clipboard.
• Select the main body of the email client and press Ctrl+V to paste that in.

Read More: How to Mail Merge from Excel to Outlook

Method 3 – Attaching an Excel File in Outlook Email

Steps:

• Open the new mail section of the Outlook email client.
• Go to the Insert tab.
• Select Files under the tab options.

• Go to the file Explorer to the location where your file is saved and select the file.
• You will find that the file is now attached to the email client.

Read More: How to Send Email from Excel List

Download the Practice Workbook

You can download the workbook used for the demonstration from the link below.

Related Articles

• Creating a Mailing List in Excel
• Mail Merge from Excel to Excel
• How to Mail Merge from Excel to Powerpoint
• How to Change Date Format in Excel Mail Merge
• How to Format Address Labels in Excel

<< Go Back To Mail Merge Excel | Learn Excel