Thank so much for watching my video. Please note, I am not allowed to include square brackets the description of the video, so that if you copy the code from the description, I have replaced >, , and < symbols with text. Before using the code check for these instances.
Thanks for this awesome video which explains step by step process and you can see how its executing the code. but one thing to note is that the signature that are added do not match exactly the signature embedded in outlook app. is there a way to create these with company logo and font/text / format?
I was looking around for a solution and majority suggesting utilization of outlook template. I like your trick of storing signature in a variable and then reusing the stored data at the end of the code.
I just tried the trick with a code to paste excel range (like a table) into mail body. The signature got pasted in first line of the table. Any idea how to make signature appear at the very bottom of mail body?
Hi, thank you for this "almost good" solution, but you might have very low security settings in outlook because when Excel read the signature in your open mail, you should have a security message that you can't remove... almost good ... still looking for a real solution
Sam, I have found the best way to get your signature and log in the email is to use a template. Look at this video ua-cam.com/video/IbHIU2jyk6Q/v-deo.html
Good Day Barb. Great video. I have an Issue when running the code. when I get to the Signature = emailMail.body i get a debug error and I can't move forward any Ideas. Everything else up to that point works.
I have found that sending email with an outlook template is much easier way to get the signature on your email. ua-cam.com/video/IbHIU2jyk6Q/v-deo.html
He’s asking if there is any way to keep a signature which nowadays contains pictures (logos)…hope you can advise since I’m suffering the same issue (without any VBA)..?
Thank so much for watching my video. Please note, I am not allowed to include square brackets the description of the video, so that if you copy the code from the description, I have replaced >, , and < symbols with text.
Before using the code check for these instances.
This helped me realise that stepping through the code can help solve something simple when rearranging code, thank you for your help!
Glad it helped, When I write code I always step through it the first time to spot any problems
@@BarbHendersonconsulting You’re totally right - sometimes tight work deadlines make you forget the basics! Haha, have a great weekend.
Thanks for this awesome video which explains step by step process and you can see how its executing the code. but one thing to note is that the signature that are added do not match exactly the signature embedded in outlook app. is there a way to create these with company logo and font/text / format?
I answered your email. Creating a template works better as seen in this video ua-cam.com/video/IbHIU2jyk6Q/v-deo.html
Very thorough, well done Barb!
I was looking around for a solution and majority suggesting utilization of outlook template. I like your trick of storing signature in a variable and then reusing the stored data at the end of the code.
Great to hear!
I just tried the trick with a code to paste excel range (like a table) into mail body. The signature got pasted in first line of the table. Any idea how to make signature appear at the very bottom of mail body?
Im looking for this. Thank you!
Glad I could help!
Hi, thank you for this "almost good" solution, but you might have very low security settings in outlook because when Excel read the signature in your open mail, you should have a security message that you can't remove... almost good ... still looking for a real solution
Thank you so much
Happy to help
After adding email and subject the signature not showing the logo which is attached with signature only showing the text not logo image. Kindly advise
Sam, I have found the best way to get your signature and log in the email is to use a template. Look at this video ua-cam.com/video/IbHIU2jyk6Q/v-deo.html
you know ive been trying to learn some VBA on my own and ive been working with it for months and had NO IDEA about F8 -.-
Wow, now that you know about it, it is a great way to find problems in the code!
that is fantastic
thanks
Good Day Barb. Great video. I have an Issue when running the code. when I get to the Signature = emailMail.body i get a debug error and I can't move forward any Ideas. Everything else up to that point works.
I have found that sending email with an outlook template is much easier way to get the signature on your email. ua-cam.com/video/IbHIU2jyk6Q/v-deo.html
You need to do this instead to preserve your signature:
.HTMLBody = "TEXT" & .HTMLBody
Is this possible?"
.HTMLBody = Sheet.Range("A1:B4").Show? & .HTMLBody.
Where the table will be first and Signature will be below.
Thanks, though the signature doesn't contain pictures and its in html format
your welcome
He’s asking if there is any way to keep a signature which nowadays contains pictures (logos)…hope you can advise since I’m suffering the same issue (without any VBA)..?
What if I already have an existing signature in my outlook and want to add that instead of having to manually type my signature?
This should procedure should work with an existing signature.