That got me far, dhookom, so I thank you!
I have a "clean" function sitting in a module so named, and I have even successfully sent emails to recipients with addresses in tblEMAIL, as per my test example. I also have the recipient list displayed in a text box on my form, as txtEmail, with names separated by semicolons in a way that Outlook works with.
Now to REALLY implement this, I need for the list of recipient email addresses to be query-specific, relating to a combo box on my form.
Here is the query that returns the correct email addresses:
SELECT DISTINCT t_wr_main.unit
FROM t_LU_issue INNER JOIN ((t_lu_team INNER JOIN (t_lu_unit INNER JOIN (t_wr_main INNER JOIN (t_issue INNER JOIN t_feedBack ON t_issue.issue_id = t_feedBack.issue_id) ON t_wr_main.id = t_issue.id) ON t_lu_unit.unit = t_wr_main.unit) ON t_lu_team.team = t_wr_main.team) INNER JOIN t_LU_eval ON t_feedBack.eval = t_LU_eval.eval_code) ON (t_LU_issue.topic = t_issue.topic) AND (t_LU_issue.issue = t_issue.issue)
WHERE (((t_wr_main.unit) Is Not Null) AND ((t_wr_main.w_date) Between [forms]![f_rpt]![cbFromDate] And [forms]![f_rpt]![cbToDate]))
ORDER BY t_wr_main.unit;
I have named that query "q_Team_RR" -- Sorry that it appears more complicated than it is!
I have not yet been able to slide this query in to the place currently held by the simple tblEmail example. That is, where you wrote me: "=Concatenate("SELECT Email FROM tblEMAIL"... I tried to put the query, and this failed.
I can display the results of this query in a list box ("lstEmail"), but when I try to put the same query into my Concatenate statement I get a run time error (3061, too few parameters?) as soon as I return to form view, with debug pointing at Set "rs = db.OpenRecordset(pstrSQL)".
I know I'm close, but I'm sticking here!
T