I wasn't sure whether i would be better to post this in SQL or ASP, but here it is...
I'm in the final stages of create a contact management database running on MS Access and ASP. In the database I have a table titled 'contacts'. We input contact info on each person and there is also a section of yes/no boxes to classify people based on their involvement with our organization. So some people may be classified in 2 groups, some people maybe 5 or 6.
I also have an SMTP email page set up. For the email recipients section, I would like to provide users with either check boxes or a combo box (where more than one option can be selected) to select an individual 'group' or 'classification' to send the email to. Meaning I want them to be presented with the same view as they are presented with when adding a new contact to the database. There is no need for the users to select individual contacts as recipients, but rather check of or click GroupA, and/or GroupB, and/or GroupC....and so on.
I would need to connect to the database first, but how do I code what I have mentioned above? As I said, I just want them to be presented with options for selecting each group name that would be recipients of the email. I can elaborate more if necessary.