Sending email with outlook signature

**sexcel** · 09-02-2008, 08:08 PM

hi all

Please Login or Register  to view this content.

This macro sends an email with a body and signature, but this works only if you manually provide the user signature file which is MySig.txt in this macro. My problem is that this same macro would be used by different users. So it should dynamically read the signature file from user's location C:\Documents and Settings\" & Environ("username") "\Application Data\Microsoft\Signatures\[user file]" and send email with that particular user's signature.

Please guide me as how this could be achieved.

**Leith Ross** · 09-03-2008, 04:24 AM

Hello sexcel,

First, let's start with path. You can this better using a different environmental variable - APPDATA. This will return the path to the Application Data folder for the logged on user. Your path to the signatures becomes...

Please Login or Register  to view this content.

Getting the proper signature file is bit tricker. Each time you create a signature, Outlook creates three different file formats for a single signature: HTML, RTF, and TXT. If you want to use only TXT files that is easy enough. But, what happens when the user has multiple signatures? Do you show all the signatures and have the user pick one?

Sincerely,
Leith Ross

**sexcel** · 09-03-2008, 03:27 PM

Thanks for helping with the Path.

Picking up TXT signature file for the specific user will do for time being.

But it will be good if the email can have the formatted signature (HTML or RTF) in it.

Please show how to do this.

**sexcel** · 09-03-2008, 07:26 PM

hi all

Could someone please help me with the problem.

**sexcel** · 09-04-2008, 10:12 PM

hi all,

If someone has any idea on this, please elt me know. Atleast how to get the TXT signature dynamically.

Any help would be highly appreciated.