+ Reply to Thread
Results 1 to 9 of 9

Cant add the default Outlook signature to email using VBA

  1. #1
    Registered User
    Join Date
    02-04-2021
    Location
    Israel
    MS-Off Ver
    365
    Posts
    9

    Cant add the default Outlook signature to email using VBA

    Hello,

    i have a VBA code that runs great as i need the only issue is that when creating the email and sending it, it sends it without the default signature of outlook, please help me

    here is the Code:


    Please Login or Register  to view this content.
    Last edited by RyanMoran1990; 05-30-2021 at 12:56 PM.

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

    Re: Cant add the default Outlook signature to email using VBA

    Hi RyanMoran1990...

    Welcome to the forum...
    Try adding red snippet between...
    Please Login or Register  to view this content.

    Also...Not sure why you have all those error trappers...
    This is how I normally do it...
    Please Login or Register  to view this content.
    Last edited by sintek; 05-27-2021 at 05:16 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
    Registered User
    Join Date
    02-04-2021
    Location
    Israel
    MS-Off Ver
    365
    Posts
    9

    Re: Cant add the default Outlook signature to email using VBA

    I just tried, and its working the same way, without the signature, i want to add that my outlook account is set up when creating a new email it already adds the signature there, the issue it looks like when it adds the "body" it replace the whole thing and deletes the signature

  4. #4
    Registered User
    Join Date
    02-04-2021
    Location
    Israel
    MS-Off Ver
    365
    Posts
    9

    Re: Cant add the default Outlook signature to email using VBA

    Quote Originally Posted by sintek View Post
    Hi RyanMoran1990...

    Welcome to the forum...
    Try adding red snippet between...
    Please Login or Register  to view this content.

    Also...Not sure why you have all those error trappers...
    This is how I normally do it...
    Please Login or Register  to view this content.
    End Sub
    I just tried, and its working the same way, without the signature, i want to add that my outlook account is set up when creating a new email it already adds the signature there, the issue it looks like when it adds the "body" it replace the whole thing and deletes the signature

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

    Re: Cant add the default Outlook signature to email using VBA

    So, you have a default signature set up and it is set up to display with outgoing emails...

    The code I provided should then do as intended...
    Also, no need to quote entire posts previously made...Just clutters the thread...

  6. #6
    Registered User
    Join Date
    02-04-2021
    Location
    Israel
    MS-Off Ver
    365
    Posts
    9

    Re: Cant add the default Outlook signature to email using VBA

    Quote Originally Posted by sintek View Post
    So, you have a default signature set up and it is set up to display with outgoing emails...

    The code I provided should then do as intended...
    Also, no need to quote entire posts previously made...Just clutters the thread...
    You are amazing Sintek! i tried the whole thing and now it works perfectly! thanks a lot!

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

    Re: Cant add the default Outlook signature to email using VBA

    ..........................
    Thanks.png

  8. #8
    Registered User
    Join Date
    02-04-2021
    Location
    Israel
    MS-Off Ver
    365
    Posts
    9

    Re: Cant add the default Outlook signature to email using VBA

    Hello,

    This code that I'm using on a computer and its working PERFECTLY, but when I added this code to another computer, it stops adding the attachment to the email, what it does instead it displays the email without the attachment and it open the code showing me the line of ".Attachments.Add PdfFile" - indicating there is an error there, it's so weird how it works fine in a PC but it doesn't on another, any ideas?

    Please help me figure this out! here is the code:

    its the same code as above!

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

    Re: Cant add the default Outlook signature to email using VBA

    Addressing a total different requirement in this thread could confuse users...I suggest opening a new thread as this one is solved...
    In the other thread...Upload a sample file as well and explain in detail what it is you are wanting to figure out...Good luck...

+ 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. Send email through Excel with default Outlook signature
    By mgnab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2019, 02:20 PM
  2. [SOLVED] How to add default signature in Outlook using VBA
    By dummy777 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2019, 08:57 AM
  3. [SOLVED] VBA adding default outlook signature to an outlook html message
    By jlive24 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2018, 11:59 AM
  4. [SOLVED] outlook VBA: how to add alternative signature to email instead of the default
    By Marijke in forum Outlook Formatting & Functions
    Replies: 13
    Last Post: 11-03-2017, 08:36 AM
  5. Use VBA to send email from Outlook and use senders default signature
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-21-2015, 11:02 AM
  6. 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
  7. 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

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