puppygirl3939
Technical User
I have been able to get this to work only if I enter the e-mail address directly into the code. How can I have the code lookup it from a query and send to more than one person.
The query must be filtered by the referral ID# on the form then is should loop and take all of the contacts on that query and format it.
Example JohnDoe@test.com;Bdoe@testing.com etc. I would call the result of the query refsend.
I believe I should then be able to add the variable to the code like this:
DoCmd.SendObject acSendReport, stDocName, acFormatSNP, refsend, "", "", "test", "Testing", , True
The query must be filtered by the referral ID# on the form then is should loop and take all of the contacts on that query and format it.
Example JohnDoe@test.com;Bdoe@testing.com etc. I would call the result of the query refsend.
I believe I should then be able to add the variable to the code like this:
DoCmd.SendObject acSendReport, stDocName, acFormatSNP, refsend, "", "", "test", "Testing", , True