+ Reply to Thread
Results 1 to 2 of 2

VBA code to email cells as a picture thorugh putlook plus add text and signature to email

  1. #1
    Registered User
    Join Date
    10-29-2017
    Location
    Miami, FL
    MS-Off Ver
    2010
    Posts
    76

    VBA code to email cells as a picture thorugh putlook plus add text and signature to email

    Hi! Below is the code I am using and it works, it pasted the cells into an email as an imagine BUT how do I add text before the image? I want the text right before the image and it just has to say “today”

    Also, this deleted my outlook signature when it pastes into the email, is there a way to put in my signature through vba?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: VBA code to email cells as a picture thorugh putlook plus add text and signature to em

    originally from here post #9 & 10
    http://www.excelforum.com/excel-prog...via-email.html

    You need to amend code slightly to keep the signature

    i wont be able to post code on post itself due to HTML coding required in code
    so find attached updated file
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] VBA Code to add Gmail signature into email
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2016, 11:00 AM
  2. VBA to adjust font in body of email and add signature to email
    By jawirth44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2015, 08:39 PM
  3. Embed a picture as a signature in an Outlook email generated by VBA in Excel
    By zach.sauls in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2013, 11:10 AM
  4. 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
  5. Add Signature to email with VBA code
    By slmi1313 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2012, 06:00 PM
  6. Unable to link default email signature to email
    By paxile2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2010, 06:52 PM
  7. Email using Excel VBA and Keeping Outlook Signature on the Email
    By Shama in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2009, 07:39 PM

Tags for this Thread

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