DoCmd.SendObject acSendReport, "Events Order", acFormatPDF, "Firstname.lastname@email.com", , , "Events Order", "Please see attached the Events Order", False
I'm using this to send a Report as PDF email and its working fine
But I would like to reference a field name on my report instead of using "Events Order"
each Events Order has Name field would like to put the name in the subject line rather than them all saying "Events Order"