+ Reply to Thread
Results 1 to 3 of 3

Paste Special from Word document to Outlook with VBA

  1. #1
    Registered User
    Join Date
    12-18-2013
    Location
    CHL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Paste Special from Word document to Outlook with VBA

    Hello guys,

    I'm trying to use a macros in VBA (excel 2010) to open a Word(2010) file, copy the content (with format) and paste on the body of a email in outlook(2010) but I can't figure it out how to use the paste special into the body of the email, so until now my code just keep the text in the clipboard, I hope someone can help me with this:

    Please Login or Register  to view this content.
    Best Regards,
    Revs

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Paste Special from Word document to Outlook with VBA

    This will get your text into the mail message, but not with formatting. You might do some web searching to get that part, or maybe someone else can chip in. If you get a "User-defined type not defined" error on DataObject, then in the VBA code window, select Tools - References, and check Microsoft Forms 2.0 Object Library. It may be near the top, rather than in alphbetical order.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-18-2013
    Location
    CHL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Paste Special from Word document to Outlook with VBA

    Thanks Natefarm!,

    I would be using that for now! thank you very much. The format is kind of important tho, so I'll keep looking for the paste to maintain the format.
    Thanks again Natefarm =)

+ 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. [SOLVED] VBA Macro to Copy from Excel and Paste Special Picture (Enhanced Metafile) in Outlook
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2013, 11:19 AM
  2. How to paste special from excel to outlook using VBA
    By drajanm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2013, 11:16 AM
  3. Word macro to email active document through outlook template
    By onbeillp111 in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2013, 12:38 PM
  4. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  5. paste special from excel to word
    By johndough185 in forum Excel General
    Replies: 3
    Last Post: 09-19-2007, 04:09 AM

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