Exchange Server Forums

Automate E-Mail Signatures (Exchange 2007/Outlook)

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [Microsoft Exchange 2007] >> Management >> Automate E-Mail Signatures (Exchange 2007/Outlook)

Page: [1] 2 next > >>

Message

<< Older Topic Newer Topic >>

Limited time MSExchange.org offer! -- 1.Sep.2008 1:00:00 PM

TechGenix and SolarWinds have partnered to provide free copies of SolarWinds Exchange Monitor to all visitors who join the MSExchange.org Forums. SolarWinds Exchange Monitor is a handy desktop dashboard that continuously monitors Microsoft Exchange to deliver real-time insight into Exchange services, mail queue sizes, and host server health. Learn more about Exchange Monitor and the free offer!

Automate E-Mail Signatures (Exchange 2007/Outlook) - 6.Jun.2007 12:22:28 PM

smartdrv

Posts: 3
Joined: 24.May2007
Status: offline

Hello

Been playing with some of Exchange 2007's features (some are probably in 2003 but I haven't touched them much).

I've learned that I can use hub transport rules to do some cool things like attach a disclaimer to outgoing messages (with all sorts of filtering options like not on internal messages). It's really cool.

This got me thinking of the next level. Signatures. Ideally signatures that will pull the information (names, numbers, titles, address) out of Active Directory. Simple is ok although the ability to toss in a logo could be cool too.

Two thoughts, either totally automated like the disclaimer (which I think would have the advantage of working in Outlook Web Access as well) or via the Outlook (2007 or possibly 2003) client (again either automated or give the user something to click - there is a Signiture button in Outlook)

I'd like to do this in the method that has the least administrative overhead (scripting and policies - something so I don't have to manually touch anything on the clients and it just works)

Any suggestions on where to start? I'm sure that this is something that many of the admins on this forum have probably delt with.

Much thanks as always!
Rob

Post #: 1

Featured Links*

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 12.Jul.2007 12:04:01 PM

Studon

Posts: 23
Joined: 31.May2007
Status: offline

Hello,

I am just looking into doing just that. If you happen to come across any info on this please let me know or post here. I will do the same.

We have used a third party app in the past but it was an added cost due to licences and we would like to utilize E2K7 to do this if it is possible.

Good luck in your search and I hope we can find something to facilitate this.

_____________________________

Chris
Systems Administrator
Studon Electric

(in reply to smartdrv)

Post #: 2

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 12.Jul.2007 4:44:11 PM

a.grogan

Posts: 1917
Joined: 12.Apr.2005
From: London
Status: offline

Hey Guys, have you folks seen this article here http://www.microsoft.com/technet/technetmag/issues/2006/10/HeyScriptingGuy/default.aspx

Its not part of Exchange 2007, but can simply be added into a logon script and then second script in the download package allows your to draw data from AD.

Just a thought,

A

_____________________________

Andy Grogan
MSExchange.org Forums Moderator
For my general ramblings about Exchange please visit my website:
W: http://www.telnetport25.com/
B: http://telnetport25.wordpress.com/
M: manifoldmaster@gmail.com

(in reply to Studon)

Post #: 3

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 7.Aug.2007 10:09:39 AM

stuarta

Posts: 44
Joined: 7.Aug.2007
Status: offline

Ok, just downloaded this and looks as though it's exactly what I wanted, but struggling to configure it.

I've managed to pull out most of it, but want to add fax number and web address, and be able to show the difference in fax and phone number. Also it's got carriage returns between each line and want to put some lines such as title in bold.

On Error Resume Next
Set objSysInfo = CreateObject("ADSystemInfo")
strUser = objSysInfo.UserName
Set objUser = GetObject("LDAP://" & strUser)
strName = objUser.FullName
strTitle = objUser.Title
strCompany = objUser.company
strAddress = objUser.streetAddress
strCounty = objUser.St
strPhone = objUser.telephoneNumber
strFax = objUser.faxnumber
Set objWord = CreateObject("Word.Application")
Set objDoc = objWord.Documents.Add()
Set objSelection = objWord.Selection
Set objEmailOptions = objWord.EmailOptions
Set objSignatureObject = objEmailOptions.EmailSignature
Set objSignatureEntries = objSignatureObject.EmailSignatureEntries
objSelection.TypeText strName & ", "
objSelection.TypeParagraph()
objSelection.TypeText strTitle
objSelection.TypeParagraph()
objSelection.TypeText strCompany
objSelection.TypeParagraph()
objSelection.TypeText strAddress
objSelection.TypeParagraph()
objSelection.TypeText strCounty
objSelection.TypeParagraph()
objSelection.TypeText strCompany
objSelection.TypeParagraph()
objSelection.TypeText strPhone
objSelection.TypeParagraph()
objSelection.TypeText strFax
Set objSelection = objDoc.Range()
objSignatureEntries.Add "AD Signature", objSelection
objSignatureObject.NewMessageSignature = "AD Signature"
objSignatureObject.ReplyMessageSignature = "AD Signature"
objDoc.Saved = True
objWord.Quit

< Message edited by stuarta -- 7.Aug.2007 10:39:30 AM >

(in reply to a.grogan)

Post #: 4

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 16.Aug.2007 11:24:02 AM

stuarta

Posts: 44
Joined: 7.Aug.2007
Status: offline

ok managed this now

On Error Resume Next
Set objSysInfo = CreateObject("ADSystemInfo")
strUser = objSysInfo.UserName
Set objUser = GetObject("LDAP://" & strUser)
strName = objUser.FullName
strTitle = objUser.Title
strCompany = objUser.company
strAddress = objUser.streetAddress
strCounty = objUser.St
strPhone = objUser.telephoneNumber
strFax = objUser.faxnumber
strWeb = onjuser.wwwhomepage
Set objWord = CreateObject("Word.Application")
Set objDoc = objWord.Documents.Add()
Set objSelection = objWord.Selection
Set objRange = objDoc.Range()
Set objEmailOptions = objWord.EmailOptions
Set objSignatureObject = objEmailOptions.EmailSignature
Set objSignatureEntries = objSignatureObject.EmailSignatureEntries
objSelection.Font.Size = "11"
objSelection.Font.Name = "Calibri"

objSelection.TypeText "Kind Regards"
objSelection.TypeParagraph()
objSelection.TypeParagraph()
objSelection.Font.Bold = true
objSelection.TypeText strName & ", "
objSelection.Font.Bold = false
objSelection.TypeParagraph()
objSelection.TypeText strTitle
objSelection.TypeParagraph()
objSelection.Font.Bold = true
objSelection.TypeText strCompany
objSelection.Font.Bold = false
objSelection.TypeParagraph()
objSelection.TypeText strAddress
objSelection.TypeParagraph()
objSelection.TypeText strCounty
objSelection.TypeParagraph()
objSelection.TypeText strCompany
objSelection.TypeParagraph()
objSelection.TypeText "(t) " & strPhone
objSelection.TypeParagraph()
objSelection.TypeText strFax
Set objSelection = objDoc.Range()
objSignatureEntries.Add "AD Signature", objSelection
objSignatureObject.NewMessageSignature = "AD Signature"
objSignatureObject.ReplyMessageSignature = "AD Signature"
objDoc.Saved = True
objWord.Quit

Need to take the space out between the name and title and also spaces in the address. If I take the objSelection.TypeParagraph() it just appears on one line.

I want it to appear as

Name
Title

Company Name
Address1
Address2
Town
Post Code

< Message edited by stuarta -- 16.Aug.2007 11:25:40 AM >

(in reply to stuarta)

Post #: 5

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 3.Mar.2008 5:50:02 PM

felipeg007

Posts: 54
Joined: 9.Aug.2006
Status: offline

This should fix your spacing issue.

objSelection.Style = "No Spacing"

(in reply to stuarta)

Post #: 6

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 16.May2008 2:42:10 AM

hupakyee

Posts: 1
Joined: 16.May2008
Status: offline

Hi, I'm new to Exchange 2007 and was interested with Automated signature, can you please advice where can get info in details for this?

(in reply to felipeg007)

Post #: 7

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 16.Jun.2008 10:50:52 AM

felipeg007

Posts: 54
Joined: 9.Aug.2006
Status: offline

Below is a signature i use. it grabs all the info from AD.

___________________________________________________

On Error Resume Next
Set objSysInfo = CreateObject("ADSystemInfo")
strUser = objSysInfo.UserName
Set objUser = GetObject("LDAP://" & strUser)
strName = objUser.FullName
strTitle = objUser.Title
strCompany = objUser.company
strAddress = objUser.streetAddress
strCounty = objUser.St
strPostal = objUser.postalCode
strPhone = objUser.telephoneNumber
strFax = objUser.faxnumber
strWeb = objUser.wwwhomepage

Set objWord = CreateObject("Word.Application")
Set objDoc = objWord.Documents.Add()
Set objSelection = objWord.Selection
Set objRange = objDoc.Range()
Set objEmailOptions = objWord.EmailOptions
Set objSignatureObject = objEmailOptions.EmailSignature
Set objSignatureEntries = objSignatureObject.EmailSignatureEntries
objSelection.Font.Size = "10"
objSelection.Font.Name = "Arial"
objSelection.Font.Color = "669999"
objSelection.Style = "No Spacing"
objSelection.TypeText "Thank you,"
objSelection.TypeParagraph()
objSelection.Font.Bold = true
objSelection.TypeText strName
objSelection.Font.Bold = false
objSelection.TypeParagraph()
objSelection.TypeText strTitle
objSelection.TypeText " | "
objSelection.Font.Bold = true
objSelection.Hyperlinks.Add objSelection.range, strWeb, , , strCompany
'objSelection.TypeText strCompany
objSelection.Font.Bold = false
objSelection.TypeParagraph()
objSelection.TypeText strAddress & ", "
objSelection.TypeText strCounty & " "
objSelection.TypeText strPostal
objSelection.TypeText " | "
objSelection.TypeText "Office & Fax: " & strPhone
objSelection.ClearFormatting()
Set objSelection = objDoc.Range()
objSignatureEntries.Add "AD Signature", objSelection
objSignatureObject.NewMessageSignature = "AD Signature"
objSignatureObject.ReplyMessageSignature = "AD Signature"
objDoc.Saved = True
objWord.Quit

< Message edited by felipeg007 -- 16.Jun.2008 10:52:47 AM >

(in reply to hupakyee)

Post #: 8

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 2.Nov.2008 10:46:34 AM

pepinho

Posts: 6
Joined: 2.Nov.2008
Status: offline

quote:

ORIGINAL: felipeg007

Below is a signature i use. it grabs all the info from AD.

Hello.

I am interested too on automating the Outlook 2007 signatures in my Exchange 2007 environment. Could you explain how do you "inject" the output from your VBS script in the Outlook 2007 signature configuration.

I am at a loss about how to use the script...

(in reply to felipeg007)

Post #: 9

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 17.Feb.2009 11:12:35 AM

superdave67

Posts: 42
Joined: 19.Aug.2008
Status: offline

(in reply to pepinho)

Post #: 10

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 26.Feb.2009 8:13:16 AM

Grant Lui

Posts: 9
Joined: 26.Feb.2009
Status: offline

yea... same here !

but not just drawing First / Last name out from AD to generate automated email signiture.

I'm also thinking of drawing out the values of the OU from AD, especially in an evnironment where a business has serveral business names and domain names, so that when a company staff sending emails as different business identy the server will attach different business's disclaimer texts.

(in reply to smartdrv)

Post #: 11

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 12.Mar.2009 2:20:52 PM

umer_javed

Posts: 18
Joined: 27.Aug.2008
Status: offline

Thanks everyone it solved 50% of my problem, just littile more is require I want to add logo of our company along with signature.........
can anybody tell me how

(in reply to Grant Lui)

Post #: 12

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 13.Mar.2009 3:15:58 AM

Grant Lui

Posts: 9
Joined: 26.Feb.2009
Status: offline

quote:

ORIGINAL: umer_javed

Thanks everyone it solved 50% of my problem, just littile more is require I want to add logo of our company along with signature.........
can anybody tell me how

Hi Umer,

I'm not quite sure about how you used those vbs scripts, can you tell me ?

Thanks

(in reply to umer_javed)

Post #: 13

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 13.Mar.2009 6:05:54 AM

umer_javed

Posts: 18
Joined: 27.Aug.2008
Status: offline

I wasn't sure how to implement this, so I just started playing around with it.

I ended up saving the script as a .VBS file (auto_signature.vbs) and called it from my existing .BAT login file... which did the trick.

Dave

As its already discribed by (Dave) thanks dave, you just open your logon script file logon.bat and add the file name.
Example:

net use f: \\rbrs4\Qualitynet use h: \\rbrs4\qa5net use g: \\rbrs4\acccommon
auto_signature.vbs

save this file update group policies log off and login on client machine open your outlook you will find the signature.

and how to creat vb script just go thorugh the whole post its easy like eating pie. moreover (how to deploy logon script through gpo) check this out
http://www.petri.co.il/setting-up-logon-script-through-gpo-windows-server-2008.htm

cheers,
Omer

(in reply to Grant Lui)

Post #: 14

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 14.Mar.2009 6:48:22 PM

Grant Lui

Posts: 9
Joined: 26.Feb.2009
Status: offline

quote:

ORIGINAL: umer_javed

I wasn't sure how to implement this, so I just started playing around with it.

I ended up saving the script as a .VBS file (auto_signature.vbs) and called it from my existing .BAT login file... which did the trick.

Dave

As its already discribed by (Dave) thanks dave, you just open your logon script file logon.bat and add the file name.
Example:

net use f: \\rbrs4\Qualitynet use h: \\rbrs4\qa5net use g: \\rbrs4\acccommon
auto_signature.vbs

save this file update group policies log off and login on client machine open your outlook you will find the signature.

and how to creat vb script just go thorugh the whole post its easy like eating pie. moreover (how to deploy logon script through gpo) check this out
http://www.petri.co.il/setting-up-logon-script-through-gpo-windows-server-2008.htm

cheers,
Omer

Thanks mate, just tired and add everything and call it out from the logon script...no hope :(

Any chance it is OS and outlook version specific ?

We are still using old W2K and Outlook2K client here

(in reply to umer_javed)

Post #: 15

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 23.Mar.2009 12:00:18 AM

HimyarJ

Posts: 4
Joined: 22.Mar.2009
Status: offline

Hello Guys,

Thanks for the post but I'm having a small issue in getting it working when I open Outlook.

I put the script in the login script to be run when the user logs in to the machine.

The script works fine since the visibility is True and WinWord will pop-up in the screen and will create the signature (that is OK for now). BUT when I open Outlook 2007 the signature does not appear in the mail body.

Any help?

Thank you in advanced.
Br, HimyarJ

< Message edited by HimyarJ -- 23.Mar.2009 12:01:36 AM >

(in reply to Grant Lui)

Post #: 16

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 23.Mar.2009 2:22:17 AM

umer_javed

Posts: 18
Joined: 27.Aug.2008
Status: offline

I'm using this script which works fine with me, I'm pasting it here try this it will work for you as well

On Error Resume Next
Set objSysInfo = CreateObject("ADSystemInfo")
strUser = objSysInfo.UserName
Set objUser = GetObject("LDAP://" & strUser)
strName = objUser.FullName
strTitle = objUser.Title
strCompany = objUser.company
strAddress = objUser.streetAddress
strCounty = objUser.St
strPhone = objUser.telephoneNumber
strFax = objUser.faxnumber
Set objWord = CreateObject("Word.Application")
Set objDoc = objWord.Documents.Add()
Set objSelection = objWord.Selection
Set objEmailOptions = objWord.EmailOptions
Set objSignatureObject = objEmailOptions.EmailSignature
Set objSignatureEntries = objSignatureObject.EmailSignatureEntries
objShape = objSelection.InlineShapes.AddPicture("\\temp\logo.jpeg")
objSelection.Font.Size = "10"
objSelection.Font.Name = "Verdana"
objSelection.Font.Bold = true
objSelection.TypeText strName & ", "
objSelection.Font.Size = "10"
objSelection.Font.Name = "Verdana"
objSelection.Font.Bold = false
objSelection.TypeText strTitle
objSelection.TypeParagraph()
objSelection.Style = "No Spacing"
objSelection.Font.Size = "8"
objSelection.Font.Name = "Verdana"
objSelection.Font.Bold = false
objSelection.TypeText strCompany
objSelection.TypeParagraph()
objSelection.TypeText strAddress
objSelection.TypeParagraph()
objSelection.TypeText "Tel: " & strPhone
objSelection.TypeParagraph()
objSelection.TypeText "Fax: " & strFax

Set objSelection = objDoc.Range()
objSignature = objSignatureEntries.Add("AD Signature", objSelection)
objSignatureObject.NewMessageSignature = "AD Signature"
objSignatureObject.ReplyMessageSignature = "AD Signature"
objDoc.Saved = True
objWord.Quit

I hope it will solve your problem.

Cheers
omer

(in reply to HimyarJ)

Post #: 17

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 23.Mar.2009 2:28:55 AM

umer_javed

Posts: 18
Joined: 27.Aug.2008
Status: offline

Grant this site has solution of your problem.

http://www.kixtart.org/forums/ubbthreads.php?ubb=faq#html

Cheers,

omer

(in reply to Grant Lui)

Post #: 18

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 24.Mar.2009 3:41:44 AM

HimyarJ

Posts: 4
Joined: 22.Mar.2009
Status: offline

Thanks Omer for your reply, really appreciate it.

That code worked fine ... but I have another question,

How do I embed the signature in the outgoing mails? Means that how can I assign the signature to any mail sent from that Exchange server? Example of that could be attaching a disclaimer to all SMTP outgoing mails.

I'm still new in M$ Exchange ... any help in that request?

Thanks again for your help ...

Br, HimyarJ

(in reply to umer_javed)

Post #: 19

RE: Automate E-Mail Signatures (Exchange 2007/Outlook) - 25.Mar.2009 2:50:20 AM

umer_javed

Posts: 18
Joined: 27.Aug.2008
Status: offline

Welcome Himyar.

1. There are two ways to send e-mail through MS exchange server.
i. MS Outlook
ii. Outlook Web Access (OWA)

If you've already attached the signature script with logon script it will become the default signature in MS outlook so all the outgoing e-mails are using the signature.

but if you are using OWA then you need to add the signature manualy for each user in their owa signature or you can use the Exclaimer signature utility can buy from www.exclaimer.com

to add the disclaimer open exchange
organizationa Configuration ---> Transport Rule ---> add rule
make your disclaimer rule there.
NOTE: Disclaimer will appear in delivered mail only.

(in reply to HimyarJ)

Post #: 20