+ Reply to Thread
Results 1 to 2 of 2

Sending Group of Excel cells automatically as bitmap image to Outlook

  1. #1
    Registered User
    Join Date
    09-12-2013
    Location
    Buffalo NY
    MS-Off Ver
    Excel 2007
    Posts
    1

    Sending Group of Excel cells automatically as bitmap image to Outlook

    Hello,

    Sorry if this has been posted before but since I have very limited VBA experience, I was hoping to get some help on some code to do a particular task.

    I would like to send the attached cells (A1:I31) as a bitmap image to a predetermined number of e-mail addresses. The cells would never need to change, only the contents would change.

    If it is possible, I would also like to place a button on the sheet to initiate the macro.

    In the end, all someone would have to do is click the button and it will take cells A1:I31 and copy them as a bitmap image into an e-mail that is sent out to several people.

    Is this possible?

    Thanks in advance,
    Alex
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Sending Group of Excel cells automatically as bitmap image to Outlook

    Yes it is possible. (BTW I suggest that you may have received a better response rate if you had broken this request down into 2 or 3 sub-requests. )

    So you want 3 outcomes:
    1. Screenshot specific range in ThisWorkbook
    2. Create button in ThisWorkbook to run the Screenshot code
    3. Attach BMP screenshot to email, send email to several people.

    I'm busy right now so I'll only help you with part 1.

    Below should screenshot your range and save as BMP in your My Documents folder (disclaimer: untested)
    Please Login or Register  to view this content.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

+ 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] use macro to hide or show bitmap image
    By John Davies in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2013, 03:59 AM
  2. sending mail in outlook with image in Top center of body .
    By yogananda.muthaiah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2012, 05:06 PM
  3. [SOLVED] sending Email (via outlook) from Excel with cell range and image from external file
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2012, 11:10 AM
  4. Pasting Images to Outlook as Bitmap
    By Giugiolo in forum Excel General
    Replies: 2
    Last Post: 11-02-2011, 10:22 AM
  5. Problem Sending embedded image via outlook 2003 from Excel 2003 vba
    By sy278 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2007, 06:13 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