PDA

View Full Version : Automatically send email



chichaspowa
11-06-2010, 06:06 PM
hello again gurus :)

i have a table (table 14) column with a function showing how many day left before a cheque is validated. How would i go about sending an automatic email to the user when the record in the table shows 7 days on the column.

thx guys

Smitty
11-07-2010, 11:24 AM
How is the date changing? If it's via formula, you could use the Open event to test the date, or you could use a Calculate event. If it's manually entered you can use a change event.

If you use Outlook, see: www.rondebruin.nl/sendmail.htm

HTH,