Email a Selection of Addresses using sendobject

C

Confused Slug

I have a number of check boxes that represent a list of people to which a
report is sent via sendobject. One, many or all of the check boxes may be
'ticked'.

How can you configure access to send one email to all the recipients (based
on the ticked boxes) rather than sending a seperate email to each?
 
D

Dennis

In your code, have a string variable called something like strTo and then
loop around your check boxes and append names to the strTo string with a semi
colon to separate the list of names to receive the E-Mail
e.g.
if chkbox = true then
strTo = strTo & strName & ";"
end if
 
M

MikeB

Dennis: I have a similar problem but I don' understand your answer. What
would I put in the "To" section of the DoCmd.SendObject method if I have a
list of recipients in a query?
 
D

Dennis

Either open a recordset and loop through the recipient field for all the
records from your query or create a form based on your query and goto the
first record and get the recipient field then goto next etc. until all
recipients from your query have been added to the string.
 
Top