email to everyone listed in the table.

[discover142]

I'd like to set up an afterevent property of a commandbox to email everyone that's in the table "tbl_Staff"
how can this be done? I've tried doing Dlookup and creating other strings but I can only add one email address and one cc. how can i add multiple email address?

 

[PHV]

Use a Recordset to get all the email address you want.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[discover142]

i've tried getting rows from recordset but it's not working... Can you possibly elaboratE?

 

[PHV]

WHAT is not working ? (ie, what have you tried so far ?)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[discover142]

i guess it's mostly my syntax.

not familiar with vb and recordset etc.


i've tried doing Emails = rs.getrows()

where rs is the databse

 

[discover142]

nevermind.. found an easier way