How to send an Email with the attachment and Paste User Signature in Email Body.

0 views
Skip to first unread message

Ashu K

unread,
Sep 11, 2015, 8:50:22 AM9/11/15
to Excel VBA Lab
Dear Seniors,

I want to do an email the current active file as an attachment while also copying a specific range of cells from the sheet with the User Signature.

I have a code and it's working fine for me but it skips the User signature from outlook. I want to pick up the User Signature in the email body. (Presuming every user uses outlook and has some signature)

Kindly provide the support.



Thanks & Regards
Ashu Kenith

Ashish Kumar

unread,
Sep 11, 2015, 11:00:08 AM9/11/15
to Excel VBA Lab
Dear Ashu,

Check this...!!



Regards
Ashish Kumar
Done.xlsm

Ashu K

unread,
Sep 14, 2015, 7:39:45 AM9/14/15
to Excel VBA Lab
Dear Ashish Sir,

Working perfect for me. Thank you so much.
Reply all
Reply to author
Forward
0 new messages