Send Email via SendObject command with text from existing tables

[Monterey_Manzer]

So I've managed to figure out how to send email using a simple DoCmd.SendObject command line that is part of an event procedure I've built into my form. However, I am wondering if I can somehow paste in data from a particular field or multiple fields in the form (or the table to which the form is locked). I have attempted things similar to the following: "Blah blah blah official email language" Combo90.Value "blah blah blah" but alas I get a syntax error. Since the purpose of the email is to call attention to a specific record in the database, it would be helpful if I could figure out how to reference that record in the email text. If anyone has any thoughts on the subject and felt like sharing I would be most grateful.

[June7]

Must concatenate variables. Reference to controls is a variable. The & is the preferred concatenation operator in Access and VBA.

"Blah blah blah official email language " & Me.Combo90 & " blah blah blah"

[Monterey_Manzer]

Okay now I feel really dumb, haha. I already concatenated some of my variables so as to display Last_Name, First_Name. I should have figured that out for myself but thanks! I'm sure this will work but I will wait until I've conducted thorough testing before I mark this thread as Solved.

[nhior]

try this

On Error GoTo Err_cmdPreview_Click

Dim stDocName As String

stDocName = "Report"
DoCmd.OpenReport stDocName, acPreview, , "TransactionID=" & [TransactionID]
DoCmd.SendObject acSendReport, stDocName, acFormatRTF, Me.Combo126.Column(1), , , "Transaction Invoice", , True

[Monterey_Manzer]

Thanks! Both suggestions are working nicely for me.