Thread: vb code for default user signature

Hi

I have a macro in excel that, creates an email in outlook. The issue I have is, this spreadsheet can be used by multiple people and I want their corresponding email signature in the email when they send it

The signature code I have is :

[SigString = "C:\Documents and Settings\" & Environ("username") & _
"\Application Data\Microsoft\Signatures\]

after the signatures path i need to do a wildcard that will pick up the users signature. I know the file I want ends in .htm

can someone show me how i can use wildcard characters to pick up any users email signature.

It sounds easy, but I cant get my head round it!

Thank You

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hi

What if they have more than one htm signature?

Please put your code in tags and I'll post the solution

I have added tags havent I? This is my first post, and I couldnt find the # Roy was talking about - never mind found the #!

Ok you need:

SigString = "C:\Documents and Settings\" & Environ("username") & _
"\Application Data\Microsoft\Signatures\"
Sigstring = Sigstring & Dir(sigstring & "*.htm")