Paste Special MS Excel Worksheet range selection into Outlook Task

B

Bugman

I am trying to paste an Excel range selection into an MS Outlook Task body
using code. This can be done manually with a Copy of the range selection and
then a Paste Special into the Task body as a Microsoft Office Excel
Worksheet. The Paste Special allows me to keep the Excel cells format, cell
shading, and the cell grid. Also, if I have some columns hidden can the copy
and paste be done of just the visible columns and not the hidden ones?

I've seen code to copy and paste normal text, but it doesn't keep the Excel
cell format.
Mucho Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

paste special excel worksheet range into outlook task body 1
Special Copy, Paste Special macro 3
Paste special macro 6
Create Custom Paste Special - Row Heights 1
Need help on this strange event 1
VBA task: Copy selection in Word and paste in Excel 1
Code to copy worksheet 5
CONCATENATE code 2

Top