Problem with VB sendobject function filling in the email address in the To field
Posted on 2006-06-01
I have a form with a comand button (cmddisapproved) with an event on click. This is running the VB below:
DoCmd.SendObject acReport, "NTEGIssueLogRptNumber_testing_all", "RichTextFormat(*.rtf)", "[Query]![NTEGIssueLogQryNumber]![email]", "", "", "NTEG Issue # Disapproved" & [Forms]![frmNTEGIssuesLog_testing_all]![txtTicketNumber], "", False, ""
I am trying to use the query that runs the report listed above to pull the users email address from a table. When I run this code I get an error Run-time error 2295 unknown message recipient(s); the message was not sent.
Any help you can all give me would be greatly appreciated.