Hi,
I'm trying to find a way to send an email to all the addresses returned from a report.
This is the setup I currently have:
I have a table called contacts and a table called searches.
I have a form based upon the searches table which is used to input criteria to search against the contacts table.
The user specifies a criteria using the form and clicks a button which loads a report (using a SQL Query) to show all the matches from the contacts table. I would then like a subsequent button to email all of the matches in that report. I'd like the option to enter the subject text in outlook prior to sending and all the email addresses should to be in the BCC field.
I've been searching on forums but can't find the definitive answer.
Can anybody help?
Thanks.