Email text from field in form?

B

Bethany Sloan

I am using my employee database to track messages I pass along. I have a
Messages form that successfully creates a message for the person I have
looked up in another form.

I want to enter the message in the form I have created (becomes a record in
my "Messages" table), and when using SendObject to create the email, I would
like the "Message" field to automatically become the text in the MS Outlook
message.

TIA!
 
D

Daniel

By looking up the SendObject method in the help file you get

SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject,
MessageText, EditMessage, TemplateFile)

Therefore you simply need to assign the message control as the 8th input
variable. Something like,

Docmd.SendObject , , , "[email protected]", , , "Your Subject Goes
Here", Me.Message, ,
 
Top