+ Reply to Thread
Results 1 to 8 of 8

Use VBA to send email from Outlook and use senders default signature

  1. #1
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Use VBA to send email from Outlook and use senders default signature

    Hi all

    I have some code that sends an email gtom Outlook which works fine, but I need to have that email use the senders default email signature, as if they had written the email themselves, I've tried looking, but can't seem to find anything on this, is it possible?

    thanks

    below is the code I currently have

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    11-27-2014
    Location
    Wolverhampton, England
    MS-Off Ver
    2013
    Posts
    49

    Re: Use VBA to send email from Outlook and use senders default signature

    Hi Billdoor,

    Try:

    Please Login or Register  to view this content.
    Last edited by owenaldridge; 09-21-2015 at 06:53 AM.

  3. #3
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Re: Use VBA to send email from Outlook and use senders default signature

    thanks, I eventually found something like that, although you also need a .display in there too.

  4. #4
    Registered User
    Join Date
    11-27-2014
    Location
    Wolverhampton, England
    MS-Off Ver
    2013
    Posts
    49

    Re: Use VBA to send email from Outlook and use senders default signature

    Yeah, I just edited my post haha.

    Thanks

    Owen

  5. #5
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Use VBA to send email from Outlook and use senders default signature

    Im not certain but I believe that the default signature is added automatically however when you assign a value to .Body it overwrites.

    Try copying .Body then assigning strBody and appending the original .Body to it?

    EDIT: Ahhh beaten to it by Owen
    If someone has helped you then please add to their Reputation

  6. #6
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Re: Use VBA to send email from Outlook and use senders default signature

    thanks both, next question(s)
    1 - can I remove the warning in Outlook, so it is sent automatically?
    2 - more importantly - can I set a rule that it doesn't get sent before a certain time? I've tried adding
    Please Login or Register  to view this content.
    but that doesn't seem to have any effect

    thanks

  7. #7
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Re: Use VBA to send email from Outlook and use senders default signature

    ah, I've sort the second part, needed to have the date in there too
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    11-27-2014
    Location
    Wolverhampton, England
    MS-Off Ver
    2013
    Posts
    49

    Re: Use VBA to send email from Outlook and use senders default signature

    Hi Bill,

    What warning message do you get exactly?

    Owen

+ 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] Using Visual Basic, can I send Outlook email from an account other than the default?
    By dave7182 in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2015, 06:14 AM
  2. [SOLVED] Get Default Signature of outlook
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 08:17 AM
  3. Send email from non-default outlook account via VBA
    By moonmanhk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2014, 10:44 AM
  4. Email macro, include variable in body & add default outlook signature
    By promithius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 09:05 AM
  5. 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
  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. Getting Outlook To Add Default Signature
    By McNulty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2009, 01:17 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