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....

 Dim Sigstring As String
 
 Sigstring = Environ("appdata") & _
                "\Microsoft\Signatures\Naveen.htm"
Is there any method to capture default signature Name which is already in outlook of current user....


as username can get from
(Environ$("Username"))