I have VBA code on an Access Form that will allow me to send an email messge thru Outlook Express to the email address 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 a query? I want the email addresses 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
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 a query? I want the email addresses 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
Last edited: