Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm needing to copy text from Excel and paste as unformatted text into Outlook. I'd like to code a small macro that would do the paste special for me.
    I've read somewhere today that there is no paste function in Outlook' VBA. Is this correct? If not what are the commands to do this simple paste?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,939
    Thanks
    0
    Thanked 94 Times in 90 Posts
    It is correct - there is no Paste, unfortunately. You might be better off trying to ensure that the copy from Excel only uses text.
    Regards,
    Rory
    Microsoft MVP - Excel.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Quote Originally Posted by BillSutterfield View Post
    I'm needing to copy text from Excel and paste as unformatted text into Outlook. I'd like to code a small macro that would do the paste special for me.
    I've read somewhere today that there is no paste function in Outlook' VBA. Is this correct? If not what are the commands to do this simple paste?
    In the old days, you could figure out the number of the "command bar control" and execute that using VBA. However, I don't think this concept exists in the Outlook 2007 ribbon, or at least it isn't as easy to figure out.

    This thread has a completely different suggestion: use a third party program to convert the contents of the clipboard to plain text. Outlook. Create a button for Edit/paste Special/Unformatted text ?

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2006
    Location
    Maryland, USA
    Posts
    677
    Thanks
    17
    Thanked 57 Times in 50 Posts
    Download and run Puretext (http://www.stevemiller.net/puretext). I've used it for about 3 years now. It's a great help when pasting between applications.
    Pam Caswell

Posting Permissions

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