+ Reply to Thread
Results 1 to 12 of 12

Email signature disepear with Macro

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Email signature disepear with Macro

    Hello

    I have a Macro that initiate Emails from outlook, but despite the default set up of composed emails being with signature,

    they come up with no signature

    Can you help Please ?

    Thanks

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Email signature disepear with Macro

    Yes bimo, but can you provide your code for building the email? In the code when you say .body = .... the whole body is being replaced, that is why the signature goes away, I can help fix but need your code.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Email signature disepear with Macro

    Hi, bimo,

    please have a look at Insert Outlook Signature in mail for finding an answer for this topic.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Email signature disepear with Macro

    Quote Originally Posted by Arkadi View Post
    Yes bimo, but can you provide your code for building the email? In the code when you say .body = .... the whole body is being replaced, that is why the signature goes away, I can help fix but need your code.
    Hi Arkadi here it is

    Thanks

    Please Login or Register  to view this content.

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Email signature disepear with Macro

    bimo, give this modification a try (changes in red):

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Email signature disepear with Macro

    Quote Originally Posted by Arkadi View Post
    bimo, give this modification a try (changes in red):

    Please Login or Register  to view this content.
    Hi ARKdi, it works, however the signature is at the start of the email, I have tried moving it to the bottom but it all it did is it brought all the images in one email do you know where I want wrong please ?

    Thanks

  7. #7
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Email signature disepear with Macro

    Quote Originally Posted by Arkadi View Post
    bimo, give this modification a try (changes in red):

    Please Login or Register  to view this content.
    Hi Arkadi

    It works but I can t get them in the wright orders, I tried moving it to the end but it brought all the images in one email can you help please ?


    Thanks

  8. #8
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Email signature disepear with Macro

    I don't know what you mean by can't get them in the right orders... if you are using the code exactly as you last pasted it, then I'm a bit confused, because when I try it, I get multiple emails, and each has the signature at the bottom like it normally should. Are you running your code exactly as pasted, or removing some of the comment markers? (')

  9. #9
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Email signature disepear with Macro

    Quote Originally Posted by Arkadi View Post
    I don't know what you mean by can't get them in the right orders... if you are using the code exactly as you last pasted it, then I'm a bit confused, because when I try it, I get multiple emails, and each has the signature at the bottom like it normally should. Are you running your code exactly as pasted, or removing some of the comment markers? (')
    it s because some of the lines related to Copy pasting images were disabled here is the macro with all enabled so you can see what I mean,

    signature end up on top of the images pasted,

    Thanks

    Please Login or Register  to view this content.

  10. #10
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Email signature disepear with Macro

    Ok, based on that last code, what about this version?

    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Email signature disepear with Macro

    Super Arkadi !! it works, Thanks

  12. #12
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Email signature disepear with Macro

    You're welcome bimo, glad we could help sort it out. Could you mark the thread as solved if you are satisfied? Thanks!

+ 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 generating email but not inserting signature line
    By clabhart in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-17-2014, 12:50 PM
  2. Macro to send email with signature depending on cell content
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2013, 11:39 AM
  3. 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
  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. Attach Long email signature to existing excel macro
    By Gamegeared in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-08-2011, 01:43 PM

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