E-Miil from field

  • Thread starter Thread starter Ady
  • Start date Start date
A

Ady

Hi There
I have a querie that contains a column with e-mail address's. I would
somehow like to e-mail everyone of these e-mail address's with a pre-defined
message.

How can I achieve this?

Many thanks in advance for your patience, time and effort!

Thank you

Adrian
 
Ady said:
Hi There
I have a querie that contains a column with e-mail address's. I would
somehow like to e-mail everyone of these e-mail address's with a pre-defined
message.

How can I achieve this?
Click to expand...

Use VBA to open the query as a recordset and iterate thru the rows
sending an email to each email address using the DoCmd.SendObject method.

For more info on SendObject method see the Access VBA Help article
"SendObject Method." For info on opening a query as a recordset see the
Access VBA Help article "OpenRecordset Method."
 
Back
Top