+ Reply to Thread
Results 1 to 2 of 2

Help modifying code of pasting range into email

  1. #1
    Registered User
    Join Date
    04-03-2014
    Location
    Tijuana
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help modifying code of pasting range into email

    Hi I would like some help modifying the current code, which from a selected range copies the data and pastes it into an email subject.

    Now I would like to modify it, so that instead of sending plain text, it sends a snapshot of the range, is there a way to do this without having to save an image file on the computer?

    They way the code bellow works, is that from a specified Range, it copies it's values to the clipboard, then it stores it in Data, on the .Body part of the email we call Data.GetText to display the text of the range in the email body, is there a way to put an image in the email body?


    Please Login or Register  to view this content.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Help modifying code of pasting range into email

    Sorry, I misread your message. I thought Ron DeBruin had written on this but I couldn't find 'image in body' subject.

    But I would think at the minimum, you will need to change from .Body, to .HTMLBody.
    Last edited by Tinbendr; 04-11-2014 at 09:15 AM.
    David
    (*) Reputation points appreciated.

+ 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. [SOLVED] Modifying vba code .Formula to cell range
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-02-2014, 03:50 PM
  2. Modifying VB Code/Macro to put selection into body of email instead of attachment.
    By excelstacy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2011, 05:34 PM
  3. Pasting range of cells into Lotus Notes Email
    By just_some_guy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2010, 07:53 PM
  4. Help modifying code to check for text in a range prior to email sheet.
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2009, 06:16 PM
  5. Modifying code for copying and pasting between sheets
    By jrpettit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2008, 05:09 PM

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