Sending mail to all email adresses in subform

  • Thread starter Thread starter Sietske
  • Start date Start date
S

Sietske

Hi,

I'd like to make a button on my form which opens an Outlook new mail,
with in the "To:" field all email adresses mentioned in the customer records
of the subform.

What is the best way to do this? I was thinking of making a for-to-loop
containing something like
strAllAdresses = strAllAdresses AND "me.txtCustomerEmail" AND " ; "
and
Application.FollowHyperlink "mailto:" & strAllAdresses

but I am not exactly sure if this is the right method.
 
Hi all,

Help is no longer needed, it turned out to be an easy solution.
For whoever has the same question: I've used the answer of John Vinson on
the question "adding up subform text records" on 7-20-2006, followed by
DoCmd.SendObject acSendNoObject, , , strAllAdresses, , , Me.txtSubject.Value

Regards,
Sietske
 
Back
Top