+ Reply to Thread
Results 1 to 6 of 6

Attach a Picture in Outlook Email Body or Save to a location from Excel

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Attach a Picture in Outlook Email Body or Save to a location from Excel

    Hi I am able to create an picture from a range of data from sheet and also able to get the name of the picture
    but I am struggling to Save that picture in a desired location

    Please Login or Register  to view this content.
    My Main Target is to attach this picture in the outlook email body

    your expertise is greatly appreciated.

    My current Code is
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Attach a Picture in Outlook Email Body or Save to a location from Excel

    My Main Target is to attach this picture in the outlook email body
    Something like this

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Re: Attach a Picture in Outlook Email Body or Save to a location from Excel

    Hi Byte,
    I tried your code and it did opened email but email body shows only Test and rest pic is totally blank.

  4. #4
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Attach a Picture in Outlook Email Body or Save to a location from Excel

    email body shows only Test
    Change the subject and email body on lines 110 and 140 respectively

    rest pic is totally blank
    Does the range being sent (line 20) contain anything?

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Re: Attach a Picture in Outlook Email Body or Save to a location from Excel

    Hi Byte, Tried now and code worked absolutely fine.

    thank you so much.

  6. #6
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Attach a Picture in Outlook Email Body or Save to a location from Excel

    You're welcome. Thanks for the feedback.

+ 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] Outlook VBA to Replace Subject Line, Send Email, and Save Email to Local Location
    By ellenlewis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2024, 06:08 AM
  2. [VBA] Save Range as picture, save to file, attach to email
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2018, 07:34 AM
  3. Copy and paste Excel range as picture into Outlook email body using excel vba
    By ExcelDoc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2016, 09:29 PM
  4. Mail using VBA with the picture displaying in email body in MS outlook 2010
    By venikumar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2015, 06:45 AM
  5. Voting in outlook by clicking on picture in the email body
    By rajesh.pardhe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2015, 09:02 AM
  6. Is there a way to Copy And Paste Excel Range As Picture Into Outlook Email Body Using Exc
    By dineshsachidananda in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2014, 09:00 AM
  7. 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

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