+ Reply to Thread
Results 1 to 3 of 3

Convert Sheet to image and paste to body of email?

  1. #1
    Registered User
    Join Date
    11-27-2014
    Location
    Seattle, WA
    MS-Off Ver
    2013
    Posts
    1

    Convert Sheet to image and paste to body of email?

    I am hoping to find an answer to this here, as I have not found one (that works) elsewhere.

    I have a sheet for landscape quality inspections which I would like to email to my customers. It would be easy enough to save and send a pdf attachment and copy/paste the email address from cell A9 into the "TO" field, but my challenges are as follows:

    1. Customers aren't likely to open/download attachments on their mobile devices, so I would like to paste the active sheet as an image in the body of the email.
    2. There is a company logo that is part of the form and needs to be part of the image that is pasted into the body of the email.
    3. Other employees have limited computer skills, so I would like to have them simply fill in the form and push a button with assigned macro to create a redy-to-send email with the email address (value in cell A9) and subject of "property evaluation" already filled in.
    4. The email would begin with "Dear (value from cell J7 is customer name), (skip two lines) Below is a copy of your most recent property evaluation. Plese let me know if you have any questions." Then, the image of the sheet would appear below that text.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Convert Sheet to image and paste to body of email?

    Hi Guppygup and welcome to the forum,

    I really like a product called SnagIt from TechSmith for this kind of thing.

    Find it at http://www.techsmith.com/snagit.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Convert Sheet to image and paste to body of email?

    This is possible, however it must be done while at a manned pc. Automation will fail as SendKeys cannot work properly on a locked PC (Still looking for a solution to this)

    Anyone reading this, if you know a workaround for automated emails, let me know! I cannot get an automated image in a body, currently utilizing rangetoHTML which is not ideal for Mobile... Anyways, here is the code Gup!

    SendEmail - this you would assign to a button that lives to the right of P somewhere - Give it a go!
    Please Login or Register  to view this content.
    Creates an image and then deletes it (Saves to clipboard for send keys operation)
    Please Login or Register  to view this content.
    Jumps below the preformed body (Currently you have 2 lines available but can expand that) Pastes the image in and then copies the image with that body
    Please Login or Register  to view this content.
    Re-pastes the previously copied data after body is replaced with Signature/Disclaimer
    Please Login or Register  to view this content.

    -Eddie
    Last edited by ELeGault; 12-12-2014 at 04:45 AM. Reason: Added Lines dictated and reference to Client Name
    -If you think you are done, Start over - ELeGault

+ 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] Paste Image in Body & Email
    By dreicer_Jarr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2013, 09:31 PM
  2. Help - Attach an image from the userform into the body of an email in lotus notes
    By dragontm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2013, 05:35 AM
  3. [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
  4. Embedding a JPEG image into email body
    By bocaj315 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-26-2013, 11:46 AM
  5. [SOLVED] Adding a disclaimer changes image in email body
    By johncassell in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2012, 08:42 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