Hi I am using this code to automatically draft a email from excel but unable to get default signature.
Please help me to get default signature at the end of email.
![]()
Please Login or Register to view this content.
Hi I am using this code to automatically draft a email from excel but unable to get default signature.
Please help me to get default signature at the end of email.
![]()
Please Login or Register to view this content.
You can set your signature IN Outlook, you dont need VBA for that
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Ford,
Thank you for your reply!
I have alrady set My signature in Outlook but when i run macro defalt signature did not polulate at the end of email.
Regards,
Xlhelp
Any update!
Regards,
Xlhelp7
You can set your default signature in your gmail account.
in setting you will get the option.
hth
Sincerely,
mso3
Hi Try this below code
![]()
Please Login or Register to view this content.
Last edited by Naveed Raza; 07-19-2016 at 07:30 AM.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi Naveed
Thanks for the reply!
when i run you code it says variable not defined
Regards,
Xlhelp7
Try recording a macro to just send some dummy email and see if the sig gets left off when you run the test macro?
hi,
try this code
![]()
Please Login or Register to view this content.
Naveed, that is exactly what I am looking for. Works a treat. Thank you!
Regards,
Xlhelp7
Hi xlhelp7,
Glad to help you
if you happy with the solution then could you please close the thread and click on * Add Reputation to say thank.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks