Get Default Signature of outlook

Hi... in Excel Vba we usually use the below code to insert Outlook Signature...

we have to enter it manually the name of the Signature like below I written Naveen.htm where Naveen is my signature name in outlook..

we cant always edit the below code and enter signature names in every pc where ever I am using this Workbook to run the macro....

Please Login or Register  to view this content.

Is there any method to capture default signature Name which is already in outlook of current user....


as username can get from

Please Login or Register  to view this content.

Hello, I tried the same, its working with default signature but every time screen is displaying (flickering) for every email...even after putting screen updating as false at the beginning, and True at the end

it may be due to .Display we used instead of .Send .. any other solution....

I would say this is very good idea instead of every time editing my code and writing the signature name ....

thanks a million Alpha....