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."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query 6
Access Access Query Criterion 1
Adding data from 1 table to another table 5
Compare and fill from table 2 to table 1. 0
GOG - 2 step verification e-mail not received 4
Microsoft Windows 3
Non working samsung tablet. 3
querry for sending email 2

Back
Top