+ Reply to Thread
Results 1 to 8 of 8

Add existing image from excel sheet to the body of an email

  1. #1
    Registered User
    Join Date
    06-01-2019
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    53

    Question Add existing image from excel sheet to the body of an email

    I have a macro, which reads some data from excel, formats it as per need and then send email to my team. Currently the body of an email has only texts. I need to add three color shapes to the body of email ( Yellow, Red and Green).

    Is there any way to add color shapes in body of email ? Its totally fine, even if all colors are formatted in one image file and is attached to body of email. I saw many solutions online but they all use mmtl code to get image from server location, my team is spread out and not everyone has access to server so I want to use the image from same excel workbook. Here is the part of code I have for sending emails.

    Note - The partial code which works for email is attached in word file(I am unable to paste html code here). I just need to add one more image to the body of email from existing sheet.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Add existing image from excel sheet to the body of an email

    I have closed your other thread, please do not post duplicate threads here.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-01-2019
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    53

    Re: Add existing image from excel sheet to the body of an email

    Sorry and thank you. instead of attaching document I posted here. I tried closing the old thread but couldn’t understand how to close.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Add existing image from excel sheet to the body of an email

    No problem

  5. #5
    Registered User
    Join Date
    06-01-2019
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    53

    Re: Add existing image from excel sheet to the body of an email

    @FDibbins - Can you please help me with solution or tag someone who can help me on this. TIA

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Add existing image from excel sheet to the body of an email

    I will push this to the VBA experts

  7. #7
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Add existing image from excel sheet to the body of an email

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Add existing image from excel sheet to the body of an email

    Thanks Dave

+ 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. Add existing image from sheet 2 to the body of an email
    By Jimmy1709 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2019, 09:02 PM
  2. Replies: 0
    Last Post: 08-02-2016, 01:16 PM
  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. Need help copying a picture/image from excel to the body of an outlook email
    By kadames27 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-15-2014, 10:17 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. Replies: 0
    Last Post: 02-21-2006, 05:20 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