How to Copy and Paste Excel Table into Outlook Email

A table or chart is very useful for representing relevant data and information. When we think of creating tables or charts, we think of Microsoft Excel. Although there is a way to create a table in the Outlook email application itself, Excel just provides more flexibility in terms of formatting and editing data. So you might commonly run into scenarios where you have to copy and paste an Excel table into an Outlook email. This article will explain how to do so using 3 different methods.

How to Copy and Paste Excel Table into Outlook Email: 3 Easy Methods

You can copy and paste Excel Table into outlook email as both editable and non-editable objects. Microsoft Office programs generally allow Excel tables to be inserted directly. As Outlook is one of those applications, you can directly copy and paste them as an editable table. At the same time, you can insert the table as a picture. And there is always the old-school method of sending the file containing the table as a whole with the email.

Before we dive deep into the methods, this is the sample table we are going to use for the demonstration.

copy and paste excel table into outlook email dataset

1. Copying and Pasting Excel Table Directly from Clipboard Command

This method allows you to edit tables in the Outlook email post-pasting. In fact, this is the only method that allows us to do so. The method involves direct and simple copying and pasting an Excel table into an Outlook email. As Outlook is a part of the Microsoft 365 product family, we can do so easily.

Follow these steps for a more detailed guide.


  • First, select the table on your Excel spreadsheet.

  • Then press Ctrl+C on your keyboard.
  • After that, open the Outlook email client and go to the section where you want to paste the table (main body of the email).

copy and paste excel table into outlook email place

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

copy and paste excel table into outlook email as editable table

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

edited after the copy and paste excel table into outlook email

This is how you can copy and paste an editable Excel table into the Outlook email.

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

2. Adding Excel Table as Non-Editable Picture in Outlook Email

Apart from the previous method, you can also insert an Excel table as a picture in an email. But as you have guessed, you cannot change or edit the table this way after inserting it in an email. Either way, there can be two ways we can achieve the result-

2.1 Copying Chart as Picture and Pasting into Outlook Email

You can directly copy the chart as a picture from Excel. But unfortunately, you can’t paste it directly elsewhere. So you have to paste it on the spreadsheet first to work with it. Then you can go on to move, cut or copy it to other places.

Follow these steps for more details.


  • First of all, select the whole Excel table on the spreadsheet.

  • Now go to the Home tab on your ribbon first.
  • Then select the downward-facing arrow beside Copy you will find in the Clipboard group section.
  • After that, select Copy as Picture from the drop-down menu.

copy as a picture and paste excel table into outlook email

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

copy picture options

  • Now click on OK. Thus Excel will now copy the table as a picture and store it on the clipboard.
  • Next, paste the picture somewhere on the spreadsheet.

excel table as picture

  • Then copy the picture with Ctrl+C.
  • And paste it into the outlook email client’s main body section by pressing Ctrl+V on your keyboard.

copy and paste excel table into outlook email as a picture object

This way you can copy and paste the Excel table into Outlook email as a picture.

2.2 Copying the Snip of Table

Although a bit improper, another way you can insert the table into the email client as a picture is to take a screenshot of the chart. You can find many third-party applications available on the internet that will allow you to take a screenshot of the chart. But here we will use the windows built-in snippet to take the snip of the table which we will use to insert them into the email.

Follow these steps for the detailed process.


  • First, open up the spreadsheet and press Win+Shift+S on your keyboard.
  • Then select the area you want over the table with the help of your mouse cursor.

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

copy and paste excel table into outlook email as a picture from snippet

This is another way to copy and paste an Excel table as a picture into the Outlook email client.

Read More: How to Mail Merge from Excel to Outlook

3. Attaching Excel File in Outlook Email

Of course, you can always attach the whole file to the email, regardless of the client. This way you can always send an Excel table with the Outlook email client. You can send them directly in a .xlsx format or a .xlsm one (if it contains VBA). Other popular formats are PDF and XPS. No matter the file extension, you can follow these steps to attach the file containing the Excel chart with the Outlook email client with the following steps.


  • First of all, open up the new mail section of the Outlook email client.
  • Then go to the Insert tab in it.
  • After that, select Files under the tab options.

copy and paste excel table into outlook email by inserting files in the client

  • Next, navigate the file explorer to the location your file is saved and select the file.
  • As a result, you will find that the file is now attached to the email client.

the file inserted for copy and paste excel table into outlook email

Read More: How to Send Email from Excel List

Download Practice Workbook

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


So these were the methods we can follow to copy and paste an Excel table into the Outlook email client. Hopefully, you can now copy and paste the charts with ease now. I hope you found this guide helpful and informative. If you have any questions or suggestions, let us know in the comments below.

Related Articles

<< Go Back To Mail Merge Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Abrar-ur-Rahman Niloy
Abrar-ur-Rahman Niloy

Abrar-ur-Rahman Niloy, holding a B.Sc. in Naval Architecture and Marine Engineering, has contributed to Exceldemy for nearly 1.5 years. As a leader in Excel, VBA, and Content Development teams, he authored 114+ articles and assisted the Exceldemy forum. Presently, as a project writer, he prioritizes stepping out of his comfort zone, aiming for constant technical improvement. Niloy's interests encompass Excel & VBA, Pivot Table, Power Query, Python, Data Analysis, and Machine Learning libraries, showcasing his commitment to diverse... Read Full Bio

  1. Hi Abrar,
    I have a problem with Copy Excel Range and Paste in MS Outlook Body.
    Pasted Table have compressed Columns
    The column widths are about twice as narrow as in the original table, so the column heights are greatly elongated.
    The same happens when I copy the Excel Range manually or via VBA.
    Note: Via VBA, if I use DataType:=wdPasteHTML, the width of all cells gets very narrow, and if I use DataType:=wdPasteRTF, then most of the cells are transferred properly, and some are very deformed in width.
    Do you have any ideas?
    Best Regards

    • Greetings Andrija,
      There might be two reasons for your query. First, your default Outlook mail compose settings may not be in HTML format. Another one is that the table is pasted as Paste text and merge format (M).

      First solution:

      Go to the View tab in your Outlook app.

      Click on View Settings > Mail > Compose and reply.

      Select the HTML format for the Compose messages option.

      Second Solution:

      Your table might be compressed if you paste it as Paste text and merge format (M).

      Change it to Paste as is (P).

      We hope your issue will be resolved. Please let us know whether your issue is solved or not. The ExcelDemy team always welcomes your valuable feedback.

      Best regards,
      Bhubon Costa

  2. Thank you very much , Bhubon.
    In the meantime, I fi x theproblem (via VBA)
    rngTable = Table Range reference, OutMail = Outlook Email object.
    rngTable. Copy
    OutMail.GetInspector.WordEditor.Windows(1).Selection.PasteSpecial Link:=False, DataType:=wdPasteHTML ‘ Not OK. The width of all cells is very narrow
    OutMail.GetInspector.WordEditor.Windows(1).Selection.PasteSpecial Link:=False, DataType:=wdPasteRTF ‘ Not OK. Some Columns extremely deformed in width
    I found that simplest solution work correctly:
    OutMail.GetInspector.WordEditor.Windows(1).Selection.Paste ‘ works correctly
    Thank you for your effort! Your solutions will help me in understanding and manual work.

    Best Regards

Leave a reply

Advanced Excel Exercises with Solutions PDF