emailing from access with current date as trigger

[inthewoods]

Coding to sent emails automatically; database holds trigger date; email id;
work date; workorder information and work instructions.

After reviewing help for email confusion has set in, can someone offer
additional insight?

 

[John Nurick]

Hi,

The general idea is to set up a query that returns the records with the
relevant trigger date, and then open a recordset on this query and
iterate through it constructing and sending the emails. See
http://www.granite.ab.ca/access/email.htm for more, especially (I think)
the first link on the page.

 

[inthewoods]

Thanks John,

I'll review this information

Hi,

The general idea is to set up a query that returns the records with the
relevant trigger date, and then open a recordset on this query and
iterate through it constructing and sending the emails. See
http://www.granite.ab.ca/access/email.htm for more, especially (I think)
the first link on the page.