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