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?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks