Text Field in Email "Subject" Line

[MSAccessOldTimer]

I have a form that is filtered, made into a .pdf, inserted into an Outlook email message, and the subject line and body of the email are started. That all works great and the user can modify the message accordingly based on need before sending the email. The field name is [Associate]. Here is my current code.



DoCmd.SendObject acSendForm, "frmAssociateTraining", acFormatPDF, _
"", , , "Safety Training Record for: **enter Associates Name**", "The attachment shows the current safety-related training for the Associate indicated in the email Subject line." _
& vbCrLf & "Please contact Safety if you have any questions about the information on this record, or if you have the need to schedule training.", True


I would like to insert the employee (Associates) actual name (based on the filtered results) into the subject line, in place of the **enter Associates Name**. I have tried =[Associate], that did not work. I tried also including the form =[frmAssociateTraining].[Associate], again no luck. It just leaves that same information in the subject line.

Thanks in advance for any assistance.

[Minty]

Create strings and use that - it's easier to debug and read as well - you are missing out on concatenating the string values;

Dim sSubject as String
Dim sMessasge as String


sSubject =  "Safety Training Record for: " &  Me.Associate
sMessage = "The attachment shows the current safety-related training for the Associate indicated in the email Subject line." _
& vbCrLf & "Please contact Safety if you have any questions about the information on this record, or if you have the need to schedule training."

DoCmd.SendObject acSendForm, "frmAssociateTraining", acFormatPDF, , , , sSubject, sMessage

[MSAccessOldTimer]

Minty: thank you so much! That did the trick!!