I am creating an email from within Excel
Is there any property I can use to tell Outlook to use the default email signature when Displaying the new email? I know the user can easily add the signature to the bottom of the mail before sending but it would be easier for them if the default was applied.
Please Login or Register to view this content.
Thanks
Not 100% sure but I believe the signature is in the email until you set the .body property, which overwrites.. so try this:
Please Login or Register to view this content.
Last edited by Arkadi; 07-07-2015 at 03:26 PM.
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.
Arkadi, many thanks for your reply. That makes perfect sense but just adding the keyword & signature doesn't seem to do the trick. You are perfectly correct that the .body statement overwrites the signature as if I comment that out then the email displayed includes the signature. Any more suggestions gratefully received
Cheers
Paul
Paul, did you try the code I posted? On my end using that code produces an email with signature. please note it is not just a keyword, it was first assigned a value at the top, then added back at the end. I edited that post to show the changes I made in red.
Arkadi. Many thanks. I had missed the first part of the amendment you suggested. Apologies for that. It does work now I put that in with one minor exception. I have a jpeg within the signature which shows up when I create a normal email but is absent when I create the email from Excel. I can live with it as is but if you have any further suggestions that would be very much appreciated. Once again thanks very much for your assistance.
Paul
I'll get back to you on that in the morning, I do have an idea
Great - thanks
Paul, If html format for the email works for you, then this version ought to take care of images for you:
Please Login or Register to view this content.
Can only give you 10/10 I afraid. Works great. Thanks again for your help (and patience!)
Cheers
Paul
My pleasure Paul, thanks for the rep and marking the thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks