+ Reply to Thread
Results 1 to 2 of 2

Copy and paste functional tables with working filters from Excel into Outlook email.

  1. #1
    Registered User
    Join Date
    05-26-2017
    Location
    Burnsville, MN
    MS-Off Ver
    2016
    Posts
    50

    Copy and paste functional tables with working filters from Excel into Outlook email.

    Is there any easy way to copy all or part of a table out of Excel and paste it into Outlook and have the filters work within the body of the email?

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Copy and paste functional tables with working filters from Excel into Outlook email.

    As far as I can see, you need to work from Outlook. First, create a new message then select Insert, Excel Spreadsheet. This will create an embedded worksheet in your message.

    Next, copy the data from Excel and paste it into the embedded worksheet in Outlook. It will paste without the filter but the Excel toolbars should be visible and you can re-create the filter as needed.

    Good luck with it.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy word document and Paste it as body of Email in Outlook (using VBA from Excel)
    By Asacras in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2017, 10:23 AM
  2. Open excel attachment from email in Outlook and copy and paste into workbook
    By RubiksCuber in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2016, 10:26 PM
  3. [SOLVED] Create outlook email from excel – paste not working!
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-07-2015, 02:33 PM
  4. Copy Paste multiple tables from multiple sheets into Outlook email
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2015, 12:21 PM
  5. Is there a way to Copy And Paste Excel Range As Picture Into Outlook Email Body Using Exc
    By dineshsachidananda in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2014, 09:00 AM
  6. Copy paste a table in outlook email to excel
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2012, 04:41 AM
  7. Copy- paste from Excel to Outlook Express email
    By JERRY in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 11:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1