+ Reply to Thread
Results 1 to 7 of 7

Adding Signature to eamil using VBA

  1. #1
    Registered User
    Join Date
    02-17-2017
    Location
    Cornwall, England
    MS-Off Ver
    2016
    Posts
    23

    Angry Adding Signature to eamil using VBA

    Hi all

    I have a worksheet that users can send a copy to an individualise it adds the body text and I want to add the signature but it does not do it my code is as follow any help would be very much appreciated many thanks. As I have said this all work apart from adding the signature I have looked as so many forum and I just cant get it to add the body text and signature it always seems to be one or the other.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: Adding Signature to eamil using VBA

    It looks like it is ready to add signature here:

    Please Login or Register  to view this content.
    so before:

    Please Login or Register  to view this content.
    set signature like this:

    Please Login or Register  to view this content.
    or, if you want to change it dynamically (for serial mailing, or something), like this:
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    02-17-2017
    Location
    Cornwall, England
    MS-Off Ver
    2016
    Posts
    23

    Re: Adding Signature to eamil using VBA

    Sorry but I do not understand I am needing the signature of the person that is going to be sending this email which my change from one user to an other so need to add their default signature block many thanks

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: Adding Signature to eamil using VBA

    As I said on previous post is ready here:

    Please Login or Register  to view this content.
    if you want to use standard set signature try this (of course earlier in a code):

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-17-2017
    Location
    Cornwall, England
    MS-Off Ver
    2016
    Posts
    23

    Re: Adding Signature to eamil using VBA

    I am sorry this did not work just ended up with a lot of code added to the email

  6. #6
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Adding Signature to eamil using VBA

    I am a little confused as to what exactly you mean by "signature"?

    Seems to be multiple options ranging from a simple text string of the actual user name who is creating the email through to a more complex "email signature block" of multiple lines of string text and eventually to an image that contains a "real signature" and contact details, again for the user actually creating the email.

    Each of these will need a different solution, at least that is what it looks like to me.

    AND... as I am sure you have seen from other posts, it always helps you get an answer if you attach a sample workbook to you request.
    Cheers

    Cheers

    Jmac1947

    1. Please consider clicking on the * Add Reputation if you think this post has helped you
    2. Mark your thread as SOLVED when question is resolved

  7. #7
    Registered User
    Join Date
    02-17-2017
    Location
    Cornwall, England
    MS-Off Ver
    2016
    Posts
    23

    Re: Adding Signature to eamil using VBA

    Signature is the outlook signature block

+ 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. VBA, Eamil and signature
    By TheRockHolger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2017, 11:58 AM
  2. Replies: 3
    Last Post: 04-15-2015, 09:34 PM
  3. Adding a digital signature
    By vixim in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-17-2014, 03:17 PM
  4. Adding Signature in Email through VBA issue
    By naveenmarapaka in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 05:30 AM
  5. adding Signature to charts
    By sbueso in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-03-2012, 09:29 AM
  6. Adding Signature to send mail
    By nick_s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2010, 12:47 PM
  7. [SOLVED] Eamil formatting
    By raf53 in forum Excel General
    Replies: 3
    Last Post: 03-31-2005, 07:26 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