+ Reply to Thread
Results 1 to 2 of 2

How to send email from excel using VBA with Cell Range (Including Images) as Email Body

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    51

    Exclamation How to send email from excel using VBA with Cell Range (Including Images) as Email Body

    I want to send email from excel using VBA with Cell Range (Including Images) as Email Body, I have below code to send email as HTML body every this is coming to email body (formats & fonts) but Images are not displayed in email body. getting error "The image cannot be displayed. Your computer may not have enough memory to open the image, or the image may have been corrupted"

    Please Login or Register  to view this content.
    Some one please help me

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: How to send email from excel using VBA with Cell Range (Including Images) as Email Bod

    Hi,

    I suggest you have a look at the ron de bruin site for starters, the code examples are really helpful to novices like me

    http://www.rondebruin.nl/

    I am currently facing the same problem, the site has nearly solved my issue (look at the "with envelope" solution even if I don't understand it"

    good luck
    Last edited by jmac1947; 03-24-2014 at 05:09 AM.

    Cheers

    Jmac1947

    1. Please consider clicking on the * Add Reputation if you think this post has helped you
    2. Mark your thread as SOLVED when question is resolved

+ 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. send email through excel with different cell range in the body of the mail
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2013, 12:41 AM
  2. Images being removed when transfering email body to new email
    By jstevens124 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2013, 09:12 PM
  3. Send New Email W/ Body of Received Email, Then Delete Sent Email
    By edneal2 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 07-01-2013, 12:45 AM
  4. [SOLVED] body of email disappears when I send an email from Excel
    By ~A in forum Excel General
    Replies: 1
    Last Post: 05-16-2012, 05:22 AM
  5. Send cell range to the body of a Lotus Notes email
    By Rob0405 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-09-2009, 05:46 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