How to access stored signatures?

[Guest]

I am a beginner to VBA.

Is signatures accessible and literate their names in the dropdownlist.
Choose one, the signature appears in my customized form?

Thank you so much

 

[Michael Bauer]

Am Wed, 21 Dec 2005 06:36:02 -0800 schrieb 光光:

Do you need the names from the dropdown list, access to the files where the
sigs are stored, or do you want to insert a sig into your e-mail by code?

 

[Guest]

Both.

First I want to fill the dropdown list with the names of all his signatures
for users to select. Then to add the selected signature to the mail body.

It's like a form with two parts: Upper part the dropdown list, lower part a
mail textbox.

 

[Michael Bauer]

Am Thu, 22 Dec 2005 00:01:01 -0800 schrieb Niln Shen:

Thanks, now I understand.

All signatures are located in: c:\documents and settings\[user]\application
data\Microsoft\Signatures

There are three files for each sig, one for each format. The file names are
the sig´s names, which you can list in the dropdown box.

After the user has selected one sig, determine the mail´s format (html, rtf
or plain) and read the proper file´s content.

 

[Guest]

Thank you very much for the explanation. I used to think the signatures are
stored in registry keys which are more complicated to be accessed.

One question though:
How can my VBA code determine the [user] section in the directory name
programmatically?

Am Thu, 22 Dec 2005 00:01:01 -0800 schrieb Niln Shen:

Thanks, now I understand.

All signatures are located in: c:\documents and settings\[user]\application
data\Microsoft\Signatures

There are three files for each sig, one for each format. The file names are
the sig´s names, which you can list in the dropdown box.

After the user has selected one sig, determine the mail´s format (html, rtf
or plain) and read the proper file´s content.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

Both.

First I want to fill the dropdown list with the names of all his signatures
for users to select. Then to add the selected signature to the mail body.

It's like a form with two parts: Upper part the dropdown list, lower part a
mail textbox.

 

[Michael Bauer]

Am Fri, 23 Dec 2005 00:25:02 -0800 schrieb Niln Shen:

From Thorsten Dörfler you can download a sample
(http://www.vb-hellfire.de/knowlib/specialfolder.php)

The description is in German but the code and constants itself should be
self-explanatory.

GetSpecialFolder(ssfAPPDATA) returns "c:\documents and
settings\[user]\application data"

You then need to add the rest.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

Thank you very much for the explanation. I used to think the signatures are
stored in registry keys which are more complicated to be accessed.

One question though:
How can my VBA code determine the [user] section in the directory name
programmatically?

Am Thu, 22 Dec 2005 00:01:01 -0800 schrieb Niln Shen:

Thanks, now I understand.

All signatures are located in: c:\documents and settings\[user]\application
data\Microsoft\Signatures

There are three files for each sig, one for each format. The file names are
the sig´s names, which you can list in the dropdown box.

After the user has selected one sig, determine the mail´s format (html, rtf
or plain) and read the proper file´s content.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

Both.

First I want to fill the dropdown list with the names of all his signatures
for users to select. Then to add the selected signature to the mail body.

It's like a form with two parts: Upper part the dropdown list, lower

part
a

mail textbox.

:

Am Wed, 21 Dec 2005 06:36:02 -0800 schrieb 光光:

Do you need the names from the dropdown list, access to the files where the
sigs are stored, or do you want to insert a sig into your e-mail by code?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook



I am a beginner to VBA.

Is signatures accessible and literate their names in the dropdownlist.
Choose one, the signature appears in my customized form?

Thank you so much

 

[Guest]

Thank you so much indeed!! You are amazing! Nice holiday~

Am Fri, 23 Dec 2005 00:25:02 -0800 schrieb Niln Shen:

From Thorsten Dörfler you can download a sample
(http://www.vb-hellfire.de/knowlib/specialfolder.php)

The description is in German but the code and constants itself should be
self-explanatory.

GetSpecialFolder(ssfAPPDATA) returns "c:\documents and
settings\[user]\application data"

You then need to add the rest.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

Thank you very much for the explanation. I used to think the signatures are
stored in registry keys which are more complicated to be accessed.

One question though:
How can my VBA code determine the [user] section in the directory name
programmatically?

Am Thu, 22 Dec 2005 00:01:01 -0800 schrieb Niln Shen:

Thanks, now I understand.

All signatures are located in: c:\documents and settings\[user]\application
data\Microsoft\Signatures

There are three files for each sig, one for each format. The file names are
the sig´s names, which you can list in the dropdown box.

After the user has selected one sig, determine the mail´s format (html, rtf
or plain) and read the proper file´s content.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook



Both.

First I want to fill the dropdown list with the names of all his
signatures
for users to select. Then to add the selected signature to the mail body.

It's like a form with two parts: Upper part the dropdown list, lower part
a
mail textbox.

:

Am Wed, 21 Dec 2005 06:36:02 -0800 schrieb 光光:

Do you need the names from the dropdown list, access to the files where
the
sigs are stored, or do you want to insert a sig into your e-mail by code?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook



I am a beginner to VBA.

Is signatures accessible and literate their names in the dropdownlist.
Choose one, the signature appears in my customized form?

Thank you so much