Manage Email Signatures Centrally - For All Users

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

We are not sending stationary down to staff and the "Use this Stationary" box is not checked, however, stationary is being deleted from users signatures, even the ones we aren't deploying. Can someone tell me why this is? Here is the log from one of the users who has complained:

---------------- eMailSignature LOG file -------------------
- Started at 12/23/2008 8:09:32 AM
- sign.exe version 5.0.0 has been run for this user.
------------------------------------------------------------

Connection string to settings database:
Provider=sqloledb;Data Source=VBSQLN01;Initial Catalog=eMailSignature;User Id=emailsiguser;Password=XXXXXXXX;
12/23/2008 8:09:33 AM Begin finding user DN
User path: LDAP://DC=venable,DC=com
12/23/2008 8:09:35 AM End Finddistinguishedname
User: css02 (CN=Simanian\, Carolyn S.,OU=Users,OU=Los Angeles,DC=venable,DC=com)
12/23/2008 8:09:45 AM License Key valid for version. 5
Distinguished name set to CN=Simanian\, Carolyn S.,OU=Users,OU=Los Angeles,DC=venable,DC=com
Signatures from group 'All Los Angeles Lgl Admin Assistants' chosen due to group membership but it is not a priority group.
Signatures from group 'All Firm Support Staff' because it is a priory group.
Signatures from group 'All Firm Support Staff' chosen due to group membership and this is a priority group.

------------------- Signatures to deploy: -------------------
Default signature: Venable - Support Staff
Reply/forward signature: Venable - Support Staff
Signatures to deploy: Venable - Support Staff
Origin ID (Internal): 4
(CN=All Firm Support Staff,OU=Users,OU=Baltimore,DC=venable,DC=com)
-------------------------------------------------------------
Office version 2003 detected.
1 signature to deploy.

-> Signature Venable - Support Staff in htm format (12/23/2008 8:09:46 AM)
Number of parameters in signature: 13
Data will be read from Active Directory
Root context for css02: LDAP://DC=venable,DC=com
Signature source:
<DIV>
<A name=_MailAutoSig>((First_name)) ((Middle_initials)). ((Last_name))</A> | ((Title)) | Venable LLP t ((Telephone_number)) | f ((Fax_number)) ((Address)), ((City)) ((State/Province)) ((ZIP/Postal_Code)) <A href="mailto:((E-mail))">((E-mail))</A> | <A href="http://www.venable.com/">www.Venable.com</A> </DIV>

Signature result:
<DIV>
<A name=_MailAutoSig>Carolyn S. Simanian</A> | Legal Administrative Assistant Coordinator | Venable LLP t 310.229.9943 | f 310.229.9901 2049 Century Park East, Los Angeles, CA 90067 <A href="mailto:CSimanian@Venable.com">CSimanian@Venable.com</A> | <A href="http://www.venable.com/">www.Venable.com</A> </DIV>

-> Signature Venable - Support Staff in rtf format (12/23/2008 8:09:47 AM)
Number of parameters in signature: 13
Data will be read from Active Directory
Root context for css02: LDAP://DC=venable,DC=com
Signature source:
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial Narrow;}{\f1\fswiss\fprq2\fcharset0 Verdana;}}
{\colortbl ;\red55\green96\blue160;\red0\green0\blue0;\red0\green0\blue255;}
{\*\generator Msftedit 5.41.21.2508;}\viewkind4\uc1\par \cf1\b\f0\fs20 ((First_name)) ((Middle_initials)). ((Last_name))\cf0\b0\f1\~\cf2\b\f0 | ((Title))\cf0\f1 \cf2\f0 | \cf1 Venable LLP\cf0\f1\line\cf1\f0 t \cf2\b0 ((Telephone_number))\cf0\b\f1 \cf2\f0 | \cf1 f \cf2\b0 ((Fax_number))\line ((Address)), ((City)) ((State/Province)) ((ZIP/Postal_Code))\line\line\cf0\f1{\field{\*\fldinst{HYPERLINK "mailto:((E-mail))"}}{\fldrslt{\cf2\ul\f0 ((E-mail))}}}\cf0\ulnone\b\f1\fs20 \cf2\f0 | \cf0\b0\f1{\field{\*\fldinst{HYPERLINK "http://www.venable.com/"}}{\fldrslt{\cf2\ul\f0 www.Venable.com}}}\cf0\ulnone\f1\fs20\par
\par \cf1\b\f0
}

Signature result:
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial Narrow;}{\f1\fswiss\fprq2\fcharset0 Verdana;}}
{\colortbl ;\red55\green96\blue160;\red0\green0\blue0;\red0\green0\blue255;}
{\*\generator Msftedit 5.41.21.2508;}\viewkind4\uc1\par \cf1\b\f0\fs20 Carolyn S. Simanian\cf0\b0\f1\~\cf2\b\f0 | Legal Administrative Assistant Coordinator\cf0\f1 \cf2\f0 | \cf1 Venable LLP\cf0\f1\line\cf1\f0 t \cf2\b0 310.229.9943\cf0\b\f1 \cf2\f0 | \cf1 f \cf2\b0 310.229.9901\line 2049 Century Park East, Los Angeles, CA 90067\line\line\cf0\f1{\field{\*\fldinst{HYPERLINK "mailto:CSimanian@Venable.com"}}{\fldrslt{\cf2\ul\f0 CSimanian@Venable.com}}}\cf0\ulnone\b\f1\fs20 \cf2\f0 | \cf0\b0\f1{\field{\*\fldinst{HYPERLINK "http://www.venable.com/"}}{\fldrslt{\cf2\ul\f0 www.Venable.com}}}\cf0\ulnone\f1\fs20\par
\par \cf1\b\f0
}

-> Signature Venable - Support Staff in txt format (12/23/2008 8:09:47 AM)
Number of parameters in signature: 11
Data will be read from Active Directory
Root context for css02: LDAP://DC=venable,DC=com
Signature source:
((First_name)) ((Last_name)) | ((Title)) | Venable LLP
t ((Telephone_number)) | f ((Fax_number))
((Address)), ((City)) ((State/Province)) ((ZIP/Postal_Code))

((E-mail)) | www.venable.com

Signature result:
Carolyn Simanian | Legal Administrative Assistant Coordinator | Venable LLP
t 310.229.9943 | f 310.229.9901
2049 Century Park East, Los Angeles, CA 90067

CSimanian@Venable.com | www.venable.com
------------------------------------------------------------
Word as Editor is accepted. Default mail editor is left unchanged.
Stationery deleted.
Office version 2003: Stationary Removed.
Outlook settings are not changed.
The following pictures will be copied to Outlook:
C:\temp\OAO_logo.gif copied to Outlook
-------------- eMailSignature END LOG file -----------------
- Finalised at 12/23/2008 8:09:47 AM
------------------------------------------------------------
Status: OK
-------------- eMailSignature END LOG file -----------------
- Finalised at 12/23/2008 8:09:50 AM
------------------------------------------------------------
Status: OK

Jesper Frier · Posted: Fri Dec 26, 2008 12:44 pm Post subject: Stationary is being deleted

Please open your SQL settings DB and validate that your Cockpit settings are saved.

Question

SQL Settings DB -> Stationery table -> column active=0?

If active=1, your Cockpit settings are not saved to your SQL Settings DB.
The name of your SQL settings DB indicates that you either modified our script or upgraded the database.
_________________
</Jesper> | Test Email Signature | Showcase |

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

The value in that column is 0.

Jesper Frier · Posted: Mon Jan 05, 2009 8:04 am Post subject:

Your Cockpit stationary settings are saved successfully to your SQL settings DB.

Next step

Please open HKCU\Software\Office add-on\eMailSignature for user css02 and check that correct settings DB is used.
Open Outlook for user css02 and set Stationary.
Open Cockpit Diagnostics, right click user css02 and delete user.
Run Sign.exe again, open Outlook for user css02 and check that user created Stationary is not deleted by Sign.exe.

Stationary settings are not working for Outlook 2007 users which explains why not all your users are effected.
_________________
</Jesper> | Test Email Signature | Showcase |

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

This is not isolated. We duplicated this on several users. I tried these recommendations already actually, except for #1, but the settings DB is correct. Any other ideas?

Jesper Frier · Posted: Mon Jan 05, 2009 4:27 pm Post subject:

Hmm ... you seem to be deploying settings that are not designed in the software ... Surprised

To eliminate any errors in your SQL settings DB, please create another DB using this script without modified anything.
The default script creates eMailSignatures DB on your SQL Server and will not conflict with your existing settings DB (i.e. eMailSignature).

Question

Then connect your Cockpit to the new settings DB (File menu) and let me know if you can recreate the issue.
_________________
</Jesper> | Test Email Signature | Showcase |

Bjarne Mess · Posted: Sun Jan 18, 2009 9:18 pm Post subject:

I've been looking into this. I cannot really understand what seems to be the problem? Is it because you don't want to have any stationeries removed, and it removes it anyways? Or do you use silent deployment, and it removes the stationeries?

Please elaborate. Thanks.