+ Reply to Thread
Results 1 to 4 of 4

Copy selected range to email body as picture

  1. #1
    Registered User
    Join Date
    09-01-2016
    Location
    Guatemala
    MS-Off Ver
    2013
    Posts
    2

    Question Copy selected range to email body as picture

    Hi guys,

    I'm a beginner and just trying to understand this better.
    I'm new at this forum so I will really appreciate your help on the below;

    I just want to copy a selected range (A2:H6) to the email body (Outlook). Can you help me out with the coding needed? I pretty much want that at the moment of clicking on a 'Command Button' it will display the Outlook New Msg with the selected range pasted as an image.

    Thanks in advance!!!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Copy selected range to email body as picture

    Check it out here.

    http://www.rondebruin.nl/win/s1/outlook/bmail3.htm

  3. #3
    Registered User
    Join Date
    09-01-2016
    Location
    Guatemala
    MS-Off Ver
    2013
    Posts
    2

    Re: Copy selected range to email body as picture

    Dave, this is not working... I've tried several ways but none...

    Usually I got error with this line:

    rangetoHTML(rng)

    It says "Sub or Function not defined".

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Copy selected range to email body as picture

    I don't see that line anywhere in the page, where a bouts is it?

+ 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. 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
  2. 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
  3. 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
  4. Copy Range to EMail-Body using ClipBoard
    By Lloyd Blankfein in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-31-2014, 01:04 PM
  5. [SOLVED] Vba code copy range and paste special in email body
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2013, 12:48 PM
  6. copy excel cells into body of email as a picture.
    By faraaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2012, 11:14 AM
  7. Copy a range to the body in email message
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2008, 02:52 PM

Tags for this Thread

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