+ Reply to Thread
Results 1 to 3 of 3

Email a screenshot of specific cells from Excel

  1. #1
    Registered User
    Join Date
    07-21-2019
    Location
    West Coast, USA
    MS-Off Ver
    365
    Posts
    24

    Email a screenshot of specific cells from Excel

    I have a fee estimator that I use to determine customer costs. I want to add a button that will open up Outlook and paste a screenshot of specific cells that contain the summary, so they do not have to see the whole spreadsheet. It might be a tall order, so please let me know if this is possible. Thank you in advance.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,652

    Re: Email a screenshot of specific cells from Excel

    Welcome to the forum.

    It is certainly possible to write code to export a range of cells as a .jpg or .png file - I have done it myself, but in my case it was to paste into Word.

    Have a look here: https://www.extendoffice.com/documen...a-picture.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: Email a screenshot of specific cells from Excel

    Hi BarnieFife

    Something like this ...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. screenshot and paste to email VBA
    By russkris in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2017, 01:09 AM
  2. Macro needed: Capture Screenshot and email using Outlook
    By skultety in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2016, 09:26 AM
  3. Email a screenshot of a specifc row in an email to a specfic email address
    By Cobra75007 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-19-2015, 10:36 AM
  4. User form screenshot and email in Lotus notes
    By Raanan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2013, 07:06 AM
  5. Trying to get an screenshot and mail it to an email adress
    By basmienis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 05:26 AM
  6. Email addressess from specific cells in Excel
    By amy22x3 in forum Excel General
    Replies: 2
    Last Post: 01-19-2009, 04:22 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