A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook Signature Font Issue



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 26th 09, 04:27 PM posted to microsoft.public.outlook.program_vba
Jamie
external usenet poster
 
Posts: 42
Default Outlook Signature Font Issue

Hello there,

I'm having difficulty getting Arial as my font. It works well using Word as
mail editor, but I cannot use this as it has an unrelated issue. Font
defaults to Times New Roman - Any other Font works (eg Arial Narrow).

Also is there a way to get rid of the double line spacing?
Again, this does not happen using Word as the editor.
All signature text is picked up from the Notes field (under telephone tab in
AD) only - "strInfo".

Many thanks for any help/advice.

- SCRIPT -

On Error Resume Next

Set objSysInfo = CreateObject("ADSystemInfo")
strUser = objSysInfo.UserName
Set objUser = GetObject("LDAP://" & strUser)

strInfo = objUser.Info

Set objWord = GetObject(, "Word.Application")
If objWord Is Nothing Then
Set objWord = CreateObject("Word.Application")
blnWeOpenedWord = True
End If
Set objDoc = objWord.Documents.Add()
Set objSelection = objWord.Selection

Set objEmailOptions = objWord.EmailOptions
Set objSignatureObjects = objWord.EmailOptions.EmailSignature

Set objSignatureEntries = objSignatureObjects.EmailSignatureEntries

objSelection.Font.Size = "10"
objSelection.Font.Name = "arial"
objSelection.Font.Bold = true
objSelection.font.Color= vbBlue
objSelection.TypeText strInfo

Set objSelection = objDoc.Range()

objSignatureEntries.Add "AD Signature", objSelection
objSignatureObjects.NewMessageSignature = "AD Signature"
'objSignatureObjects.ReplyMessageSignature = "AD Signature"

objDoc.Close 0
If blnWeOpenedWord Then
objWord.Quit
End If
Ads
  #2  
Old January 26th 09, 05:03 PM posted to microsoft.public.outlook.program_vba
Jamie
external usenet poster
 
Posts: 42
Default Outlook Signature Font Issue

I have changed the line to objSelection.Font.Name = "Arial Bold"
rather than objSelection.Font.Name = "Arial" and it seems to work fine.
Still not sure why "Arial" doesn't work, but still having the line spacing
issue if anyone is able to point me in the right direction.
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automated Outlook Signature Issue paul Outlook and VBA 3 March 2nd 07 12:21 PM
Outlook signature issue CAMC1 Outlook - General Queries 0 August 23rd 06 09:17 PM
Outlook 2003 issue with Font Color Dan Outlook - General Queries 2 July 1st 06 07:28 PM
Outlook 2003 issue with Font Color Dan Outlook - Installation 2 July 1st 06 07:28 PM
Size of font in Outlook Mail Signature mdt Outlook - General Queries 1 March 15th 06 08:53 PM


All times are GMT +1. The time now is 07:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.