send email -taking the email address from subform

[Nancythomas]

I need to send email from 'Form" by a click of a button command
(1) In FrmEmail - I select the Department
(2) Subform displays the list of people from the selected Department
(3) Email to be sent to all the selected people from sub form "frmEmpMobileNos"
(4) email address is on the subform "frmEmpMobileNos"


The code just does not work




Attached is the sample DB

 

[June7]

The control named lstMobile is an OLEObject control. Why is it on the form?

Subform is not needed for this process. Use VBA to open a recordset of email addresses filtered by department and loop through recordset to build address list for email. This is a very common topic.

 

[theDBguy]

Hi. Here's one simple function that does what June7 was saying. Hope it helps...