+ Reply to Thread
Results 1 to 3 of 3

GMAIL: Attached file and paste range as image on the body of the email

  1. #1
    Forum Contributor
    Join Date
    03-09-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    235

    GMAIL: Attached file and paste range as image on the body of the email

    Hi

    Is it possible to have a vba code to copy and paste the range as picture in the body of the email and also attached a file as attachment?

    Thanks for your help in advance.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: GMAIL: Attached file and paste range as image on the body of the email

    Will the recipient of the email have access to the same network server that you have when you create the email?

    This very same topic came up only a day or two ago - see here. http://www.excelforum.com/excel-prog...ml#post4219083 Hopefully that will help
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: GMAIL: Attached file and paste range as image on the body of the email

    You should probably use CDO if you are going to use Gmail smtpserver. See Ron's example at: http://www.rondebruin.nl/win/s1/cdo.htm

    You can also use Ron's routine RangeToHTML() for the .BodyHTML.

+ 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. How to include excel cells on the email body using gmail
    By ivhee00 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2015, 10:38 AM
  2. [SOLVED] Problem with automatic email with attached sheet and range of cells as a body?
    By ExcelBG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2015, 03:31 AM
  3. Convert Sheet to image and paste to body of email?
    By Guppygup in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2014, 04:15 AM
  4. Sending mail with range as body using GMAIL
    By vssoma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2014, 05:40 AM
  5. [SOLVED] Paste Image in Body & Email
    By dreicer_Jarr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2013, 09:31 PM
  6. [SOLVED] VBA to send embedded image in email body- NOT USING THE ORGINAL IMAGE SOURCE
    By Coreyusa in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-27-2013, 06:48 PM
  7. email with corresponding addresses and names in body AND subject using gmail
    By excel4phil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-22-2013, 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