Thanks Tom I've also found that I've got the syntax wrong. It should have been olItem.HTMLBody= bodyHTLStr Instead of olItem.BodyHTML= bodyHTLStr
Regards Jane --- In AccessDevelopers@yahoogroups.com, "Tom Oakes" <[EMAIL PROTECTED]> wrote: > 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: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of vjcross2004 > Sent: Wednesday, July 20, 2005 5:01 AM > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] How to Email orders > > > Hi All > 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]! > EMail > 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. > > > > > SPONSORED LINKS > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+database&w1=Microsoft+ > access+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4= Microso > ft+access+database+design&w5=Microsoft+access+database+training&c=5&s =163&.s > ig=TjCMMZaJBtroyAQ8dznVsQ> access database Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+developer&w1=Microsoft > +access+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4 =Micros > oft+access+database+design&w5=Microsoft+access+database+training&c=5& s=163&. > sig=oqhFqsmlUZ5Zh6pQgnvTDQ> access developer Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access&w1=Microsoft+access+da > tabase&w2=Microsoft+access+developer&w3=Microsoft+access&w4=Microsoft +access > +database+design&w5=Microsoft+access+database+training&c=5&s=163&.sig =MMKzpe > wSlzpK714XaCARAQ> access > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+database+design&w1=Mic > rosoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+acc ess&w4= > Microsoft+access+database+design&w5=Microsoft+access+database+trainin g&c=5&s > =163&.sig=ecBsMdKeZw8i4_1kkC6epA> access database design Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+database+training&w1=M > icrosoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+a ccess&w > 4=Microsoft+access+database+design&w5=Microsoft+access+database+train ing&c=5 > &s=163&.sig=FHk4Yggbv_zB-TsXvHyeig> access database training > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > _____ Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
