Specify the format prior to sending:
olItem.BodyFormat = olFormatHTML
Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
713.583.7091 (F)
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of vjcross2004
Sent: Wednesday, July 20, 2005 5:01 AM
To: [email protected]
Subject: [AccessDevelopers] How to Email orders
I have created an orders database. I'm trying to automate emailing
the customer a copy of the order/quote. So far I've got:
Dim db As Database, bodyStr As String
Set db = CurrentDb
Dim ol As New Outlook.Application, myattachments As Attachments
Dim olItem As Outlook.MailItem, strAddresseesTo As String
strAddresseesTo = Forms!Enquiries.Form![Customer Address Subform]!
Set olItem = ol.CreateItem(olMailItem)
olItem.Recipients.Add (strAddresseesTo)
olItem.Subject = "Enquiry Quote"
bodyStr = "Dear " & Forms!Enquiries!CustomerContactName & "," &
vbCrLf
bodyStr = bodyStr & "Thank for for your recent enquiry. " & vbCrLf &
vbCrLf
bodyStr = bodyStr & "Enquiry No: " & vbTab & Me!EnquiryNo & vbCrLf
olItem.Body = bodyStr
olItem.Display
I'm happy that I can send this email. I'm now trying to format
Item No Qty Description Price Each Total
into columns with each lining up & I'm really struggling. Ideally
I'd like to format it so that I can add bold/underlines etc. I've
looked at a HTML editor:
http://www.lebans.com/htmleditor.htm
I can get the HTL code I need, but I don't know how to send the
email so that it's in HTML.
I've tried
bodyHTLStr= "<P align=center><STRONG>Test of this Memo
field.</STRONG> Rec #1</P>"
olItem.BodyHTML= bodyHTLStr
but it doesn't like it. I think it something to do with EditorType
property, but I can't figure out the syntax.
Can anyone help?
Thanks
Jane
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
