By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,990 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,990 IT Pros & Developers. It's quick & easy.

Send Object Formatting

P: n/a
I am trying to use the following code to create an email message which
takes its body from values stored in a form. I want to split the values
up so I have added some line breaks to strBody. These work in acccess
but as soon as they are transferred to outlook they disapear.

Is there a way to keep formatting while transferring to outlook?

TIA

Private Sub Command159_Click()
Dim strEmailAddress As String
Dim strTitle As String
Dim strBody As String

strTitle = Me.txtTitle.Value
strBody = Me.txtTitle & Chr(13) & Chr(10) & Me.txtAnno.Value & Chr(13)
& Chr(10) & Me.txtDescription.Value & _
Chr(13) & Chr(10) & "" & Me.txtPrice.Value
strEmailAddress = "rt*******@blueyonder.co.uk"

DoCmd.SendObject acSendNoObject, , , strEmailAddress, , , strTitle,
strBody, -1

End Sub

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If you're using SendObject, AFAIK, you're not using Outlook at all, but
(probably) only Simple MAPI. If you have to have the stuff formatted,
then automate *Outlook*, and don't use SendObject. Then you can format
until you're blue in the face.

Look at Tony Toews site or at MS for examples. or search the NG for
Outlook.

I know they're around, as I've read a lot of them.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.