Sending Bulk Email From Access Thru Outlook Epress

[Mike]

I have code that will allow me to send and email messge
to the email addres in a field, but is there a way,
using a modification of the same code to Send Bulk email
to every email address in that field in my database Using
a Query?

I can get the code to read an email address in a single
field from a form, but could I have it retrieve all
email addresses from an external query. I want the email
address to appear ready to send from MS Outlook Express
in the Bcc: field to everyone in my Database.

Form so far:
Feild which contains email address.
On click button that opens Outlook express and places
email address in the To: CC: or Bcc: line (based on code).

code i have got so far:
______________________________________
Private Sub Email2_Click()
DoCmd.SendObject _
, _
, _
, _
("" & Me!EmailAddress), _
, _
, _
, _
, _
True
End Sub
_______________________________________
Private Sub Form_frm_Missions_Main2()
Me!Email2.Enabled = Not (IsNull(Me!EmailAddress))
End Sub

Can anyone help

 

[John S]

I think this has been answered, but all you need to do is call the
recordset, and with each rs.next(), use your docmd.sendobject. That way, you
will cycle through each record in you database, and send out each email.

I've done this with javamail; it would be interesting to know if MS Access
can efficiently handle a bulk emailing in this way (i.e., how many records,
and how long did it take) . Maybe you could inform the group of your
experience with it in a bulk email mailing.

John S
Aylmer, PQ