button on form to send email message

L

Linda in Iowa

On my form is a button that will open the email program. I am using
doCmd.SendObject. In the messagetext part of this command is it possible to
code the message to show on the email as 4 lines? Is it possible to code
the font you want the message to be in or does it just default to what your
email program currently is set up for? The actual message is entered in the
messageText part of the DoCmd.SendObject.

DoCmd.SendObject acSendNoObject, , , Me!EMAIL, , , "subject", "message text
line 1 message text line 2 message text line 3 and message text line 4"

using access 2003
 
F

fredg

On my form is a button that will open the email program. I am using
doCmd.SendObject. In the messagetext part of this command is it possible to
code the message to show on the email as 4 lines? Is it possible to code
the font you want the message to be in or does it just default to what your
email program currently is set up for? The actual message is entered in the
messageText part of the DoCmd.SendObject.

DoCmd.SendObject acSendNoObject, , , Me!EMAIL, , , "subject", "message text
line 1 message text line 2 message text line 3 and message text line 4"

using access 2003

Try:

DoCmd.SendObject acSendNoObject, , , Me!EMAIL, , , "subject", "message
text line 1" & vbNewLine & "message text line 2" & vbNewLine &
"message text line 3" & vbNewLine & "and message text line 4"
 
L

Linda in Iowa

After I sent this I tried the vbCrLf and that also did the trick.
Any thoughts on the font style and size?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top