+ Reply to Thread
Results 1 to 6 of 6

Paste Excel range into Outlook message body as picture

  1. 03-27-2016, 06:29 PM #1
    Andrew Entee
    Andrew Entee is offline
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Paste Excel range into Outlook message body as picture

    I'm trying to copy and Excel range and paste it as an image into the message body of an Outlook email the code I have so far works (with the message body as a simple string). How do I change it to paste the image of the range I have in the "PasteIt" variable.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 03-27-2016, 07:02 PM #2
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Paste Excel range into Outlook message body as picture

    This might get you in the right direction..
    http://vba-useful.blogspot.fr/2014/0...ed-images.html
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom
    Reply With QuoteRegister To Reply
  3. 03-28-2016, 07:25 PM #3
    Andrew Entee
    Andrew Entee is offline
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Paste Excel range into Outlook message body as picture

    Thanks Tom. I'll try that. cheers
    Reply With QuoteRegister To Reply
  4. 03-28-2016, 07:31 PM #4
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Paste Excel range into Outlook message body as picture

    You're welcome....good luck.
    Reply With QuoteRegister To Reply
  5. 04-12-2016, 05:17 PM #5
    Andrew Entee
    Andrew Entee is offline
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Paste Excel range into Outlook message body as picture

    this is what finally worked... (with Trendline added)

    Please Login or Register  to view this content.
    '
    Reply With QuoteRegister To Reply
  6. 04-12-2016, 05:49 PM #6
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Paste Excel range into Outlook message body as picture

    I'm glad you were able to get it figured out.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract Subject and Body of an Outlook Message into Excel
    By Saarang84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2016, 12:31 AM
  2. Copy and paste Excel range as picture into Outlook email body using excel vba
    By ExcelDoc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2016, 09:29 PM
  3. Copy Range to Body of Outlook Message and Display
    By Branbran10 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2015, 07:29 PM
  4. Help with Copy Range from Tab and Paste In Outlook Email Message Body.
    By N4VBA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2014, 03:40 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. Need help copying a picture/image from excel to the body of an outlook email
    By kadames27 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-15-2014, 10:17 AM
  7. Body of outlook message to Excel
    By dougmorgan in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2013, 09:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1