Insert signature from Access 2003
 

Hi Sue -

When I append to the body, it reformats my signature. How can I keep the
format of my signature and still append new text to the body??

Thanks!

"Sue Mosher [MVP-Outlook]" wrote:

You're overwriting the signature when you set the Body property to new text rather than appending to Body.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"hughess7" wrote in message ...
Hi Sue

I have a default signature but it does not insert it. I am using:

Dim objOutLook As Outlook.Application
Dim objMail As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient

Set db = CurrentDb()

Set objOutLook = New Outlook.Application
Set objMail = objOutLook.CreateItem(olMailItem)

With objMail
' Add the To recipient(s) to the message.
Set objOutlookRecip = .Recipients.Add("Itinerary")
objOutlookRecip.Type = olTo
For Each objOutlookRecip In .Recipients
objOutlookRecip.Resolve
Next
.Display
.Subject = "Weekly Itinerary"
.Body = "Please find attached the weekly Itinerary for w/c " &
Format(DateAdd("d", 2 - Weekday(Date), _
Date + 7), "dd mmmm yyyy") & vbCrLf & vbCrLf & .To
If Not IsMissing(strFile) Then
.Attachments.Add (strFile)
End If
End With

Thanks
Sue


"Sue Mosher [MVP-Outlook]" wrote:

What method are you using to create the message? Outlook's Application.CreateItem should automatically insert the user's default signature, if they have one.

"hughess7" wrote in message ...
Hi all

I have code in my Access db to create an email message using the Outlook
object. I would like the default signature to be inserted at the end of the
email. It is used by multiple people on different PCs (all using windows 2003
terminal server). Each have Outlook set to create a default signature in a
new email but my code seems to ignore this? I am displaying the message
before it is being sent (by manually pressing the send button). Is there a
way to access the default signatures for the individual clients? I have tried
looking on newsgroups and google etc but not found a definitive answer and my
coding skills are only very basic!

The signatures files exist in the c:\documents and settings\user folders -
do I need to find the network logon name and use if statements to add the
file dependant upon who is logged on or is there an easier method? Did try
asking this in the Access newsgroups but was told to ask here...

Thanks in advance for any help.
Sue