Christine Pearc
Christine
- Local time
- Today, 15:52
- Joined
- May 13, 2004
- Messages
- 111
Without any responses from my post of 3-Mar, I'm hoping that this re-post will bring some help my way!
How do you tell Access to send email in HTML, with the user's signature (set in Outlook) - rather than Plain Text? I am sending an attachment, but the formatting for that is okay; it's the body of the email (the message) that's of concern.
Here's my current code:
Thanks,
Christine
How do you tell Access to send email in HTML, with the user's signature (set in Outlook) - rather than Plain Text? I am sending an attachment, but the formatting for that is okay; it's the body of the email (the message) that's of concern.
Here's my current code:
Code:
Dim MyOutlook As Outlook.Application
Dim MyMail As Outlook.MailItem
Dim fso As FileSystemObject
Set fso = New FileSystemObject
Set MyOutlook = New Outlook.Application
Set MyMail = MyOutlook.CreateItem(olMailItem)
MyMail.To = MailList
MyMail.Subject = SubjectLine
MyMail.Body = MyBodyText
MyMail.CC = ccList
MyMail.Attachments.Add "M:\Pub\CPA\rptCAR.snp", olByValue, 1, "CAR Rrt"
MyMail.Send
Set MyOutlook = Nothing
Thanks,
Christine