+ Reply to Thread
Results 1 to 9 of 9

Email Macro paste image in to email and sent to list in designated range Outlook

  1. #1
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Email Macro paste image in to email and sent to list in designated range Outlook

    Need help making this macro work with semailto causing problems is one of the errors.

    If there is a better way to this please any help would be amazing.

    I have attached file

    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: Email Macro paste image in to email and sent to list in designated range Outlook

    Try this...

    As attachment...
    Please Login or Register  to view this content.
    Imbedded into Email body...
    Please Login or Register  to view this content.
    Last edited by sintek; 04-12-2020 at 08:29 AM.
    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!!!

  3. #3
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Re: Email Macro paste image in to email and sent to list in designated range Outlook

    is there any way to have it pasted in to the body of the email rather than an attachment? and when it is pasted in the body of the email it remains in a table format ?

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

    Re: Email Macro paste image in to email and sent to list in designated range Outlook

    I gave two options above...See 2nd option....

  5. #5
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Re: Email Macro paste image in to email and sent to list in designated range Outlook

    This is perfect thank you for all your help

    sintek is amazing and cant thank you enough for all your help 5 star answer

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

    Re: Email Macro paste image in to email and sent to list in designated range Outlook

    ..........................
    THANKS.gif

  7. #7
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Re: Email Macro paste image in to email and sent to list in designated range Outlook

    How would you adjust body2 ahead of jpg table?

    body
    body 2
    jpeg

    Please Login or Register  to view this content.

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

    Re: Email Macro paste image in to email and sent to list in designated range Outlook

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Re: Email Macro paste image in to email and sent to list in designated range Outlook

    thanks again that's perfect

+ 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] Macro to Email set of cells with identified email list and subject line with outlook
    By aaron061883 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2020, 01:18 PM
  2. Replies: 0
    Last Post: 05-28-2018, 09:53 AM
  3. With AutoFilter - copy email address in active cell & paste in To field of Outlook email
    By carmen.swanson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2015, 09:40 PM
  4. GMAIL: Attached file and paste range as image on the body of the email
    By albert28 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2015, 08:10 PM
  5. Help with Copy Range from Tab and Paste In Outlook Email Message Body.
    By N4VBA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2014, 03:40 PM
  6. send selected range in email with default outlook email signature included
    By mdsickler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 10:50 PM
  7. [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

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