+ Reply to Thread
Results 1 to 2 of 2

How to copy a range and paste it into email as a picture

  1. #1
    Registered User
    Join Date
    09-30-2018
    Location
    Dhahran, Saudi Arabia
    MS-Off Ver
    2016
    Posts
    1

    How to copy a range and paste it into email as a picture

    I've been googling this the past couple of days and haven't found a suitable response. I have a code that sends an automatic email when a certain value is changed.

    The code will send a range in the body of the email. My issue is I've a conditional icons formatting in that range which will disappear when the range is copied and paste in the email.

    Can any one help me solving this issue?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: How to copy a range and paste it into email as a picture

    i have a working example on this site

    http://www.excelforum.com/excel-prog...via-email.html
    see Post #10
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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 cells from Excel and paste as a picture in an email.
    By oneyejack77 in forum Excel General
    Replies: 4
    Last Post: 04-09-2018, 12:22 PM
  2. Excel vba paste range into email body as picture
    By prabhubox@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2018, 04:07 AM
  3. [SOLVED] Send Copied Range into New Workbook & Email w/ Outlook - How to copy picture!?
    By brianfu777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2017, 02:55 PM
  4. Copy selected range to email body as picture
    By tmzmonko in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2016, 02:08 AM
  5. 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
  6. 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
  7. Marco/VBA to copy a selection and paste into an email as a picture
    By jsneak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2014, 05:53 AM

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