Create a recordset for your checkdate with the MemberID's to print and their Email-address
Something like: (aircode)
Dim db as database, rst as recordset
Set db=CurrentDb
set rst=db.OpenRecordset("YourRecordset")
Do untl rst.EOF
DoCmd.OpenReport "YourCheckReport", acViewNormal , , "Where ID = " & rst!ID
DoCmd.SendObject , , , rst!Email, , , "Automated check-mail", "Message text here"
rst.Movenext
Loop
Arno R
"1800AD" <p.*********@gmail.com> schreef in bericht news:11**********************@j33g2000cwa.googlegr oups.com...
Need to create a procedure that will print checks but post a message
after every check.
it has been 7 years since i did ms access. the report would be using 2
parameters, the member id and the check date, from which i will be
reading from a table.
your help will be greatly appreciated. thanks.