Manage Email Signatures Centrally - For All Users

lukejarden · Not too shy to talk Joined: 27 Mar 2008 Posts: 5

Hello I was hoping you could help me with a simple vbs script to start sign.exe and connect it to a sql db.

location of sign.exe is in the same location as login script but i would like to keep them seperate for now during testing.

I tried below, but not to sure of the required vbs syntax

Run ("\\xxx.com.au\SysVol\xxx.com.au\Policies\{92CA0FDB-632E-4D52-9889-E582CB3D8F8F}\User\Scripts\Logon\sign.exe Provider=sqloledb;Data Source=xxxSQLSERVER;Initial Catalog=eMailSignature;User Id=id1;Password=password1;")

Jesper Frier

Please see if this post helps you?

lukejarden · Not too shy to talk Joined: 27 Mar 2008 Posts: 5

Thanks for the link Jesper, But from what I can see that is only vbscript to be used as a logon script using perhaps the default Microsoft settings.mdb and doesnt show code on how to connect to an SQL DB. From the the code below:

Run ("\\xxx.com.au\SysVol\xxx.com.au\Policies\{92CA0FDB-632E-4D52-9889-E582CB3D8F8F}\User\Scripts\Logon\sign.exe Provider=sqloledb;Data Source=xxxSQLSERVER;Initial Catalog=eMailSignature;User Id=id1;Password=password1;")

Can you see anything thats looks out of the ordinary. 1st our domain is listed then the folder in which Sign.exe is located. (a share all users have access to) then provider, data source, db, and autheticaiton credentials. Can you pls supply some example code of working example where sign.exe is in the sysvol folder (emailsignatures suggestion) and connected to an slq db. Thanks

Jesper Frier · Posted: Mon Mar 31, 2008 10:00 am Post subject:

Please try this:

lukejarden · Not too shy to talk Joined: 27 Mar 2008 Posts: 5

The supplied code works a treat in a batch file, thanks for your help Jesper.

Last query now that i am happy with the process of rolling out the demo sig, In the demo version am I able to push out and test my own sig file that I have created in cockpit? Also what features are able to be tested in the demo version, Can I use the address book tool and also create disclaimers on the bottom of signatures ect...

Jesper Frier · Posted: Wed Apr 02, 2008 5:06 am Post subject:

In TRIAL mode, you can deploy any signatures created in your Cockpit. The only difference from the licensed version is that a TRIAL message appear below the signature.

The features available in the TRIAL version is the same the features you end up purchasing.
Only if you have special requirements, we might need modules features (Learn more in the modules section of this forum) or here on the web site. Modules are licensed by changing your license key only - no need to change the installation.

If you only need to manage email signatures, the downloaded version will do the trick .. Cool