confidential email list through email client
Hi I am trying to implement an email feature that will work in the following way:
-The database contains data about individuals and each form has a field for an email address
-Users can perform a search to specify which users they would like to email (eg. all people who share some attributes such VISA expirey date)
-Users can then send an email to these users through their email client
Seems straightforward enough, and I easily wrote a script that finds the email address in the field of all the records that came up with the user's search. However, I am having some issues with the actual email step.
I would like to be able to send one email where all the emails are confidential (i.e. they are not all explicitly listed). The best that I seem to be able to do is to send one email to each person (and this doesn't work very well if there are 50+ people returned with a search because you have to click send mail 50+ times which is really annoying).
It would be great if someone could please provide me with some pointers on how to achieve this.