Generate an email from Access Field

[jjdurrant]

I would like to know how I could trigger Access 2003 to send an e-mail. I can find how to send e-mail, but I want it to do it automatically based on a date field. The idea is that the user would enter a quote and they want an e-mail reminder two weeks after the quote is entered to follow up on the quote.

Any Ideas?

 

[CindyK]

Am I understanding you correctly that you don't want the email to go out until 2 weeks later? I'm not sure if you're looking for code specifics, or thoughts on how to approach the task...??

If the database is used every day, you could do a search on the open of the database to see if any email reminders are due to be sent, and ask the user if they want to do it at that time. It could be a simple select query that looks for a date range. Add a field to the table that flags when it's done to avoid sending duplicates.

Create a recordset of the records to be sent, and then step through the records one at a time in VBA, using your send mail code. As you do the step through, do a record update to flag that the reminder has been sent.

One word of warning, though - later versions of Outlook (if that's the mail client you're using) will warn the user that emails are being sent, and will prompt for permission. I don't think there's an easy way to override that warning message.

If this is a multi-user database you might tie it into the user - kicking off the message only if it's user A (for example).

Just some thoughts...!

 

[jjdurrant]

I am looking for ways to approach the task, and code examples and\or specifics. The db is opened daily and is used by mult users.