My DoCmd.SendObject to send a report in PDF to selected individuals. And it works if I type in the email address into the DoCmd.SendObject code. However, I need my form to select the "To:" person with a Combo control. The Combo control then holds the correct email address.
In the DoCmd.SendObject I have tried several items in the space reserved for "To:" Me.EmailDD "Me.EmailDD", [EmailDD], and "[EmailDD]"
Nothing works. The code is run by a command button on the Form that contains the Combo control (EmailDD)
The form name is "IPSS Open Courses"without the quotes.
Please: Where am I going wrong.
Thanks
John
In the DoCmd.SendObject I have tried several items in the space reserved for "To:" Me.EmailDD "Me.EmailDD", [EmailDD], and "[EmailDD]"
Nothing works. The code is run by a command button on the Form that contains the Combo control (EmailDD)
The form name is "IPSS Open Courses"without the quotes.
Code:
DoCmd.SendObject acSendReport, "EOC Sheet rpt", acFormatPDF, [COLOR=#EF2929]"I need the EmailDD value here"[/color], , , "Class EOC", "You can use this form to print the number of copies you need." & Chr(10) & Chr(10) & "Thanks." & Chr(10) & "John J. Schreiber", False
Please: Where am I going wrong.
Thanks
John