Automated E-mail

[imintrouble]

Hello Access Forums!



I have the need to let my query which keeps track of the day a package was sent, to send an e-mail to people's e-mail accounts a specified number of days AFTER the day which the package was originally sent. This can be referred to as a follow-up e-mail.

First I'd like to know if this is possible. If so, please inform me on how to proceed. If not, well now I know.

Best,

Imintrouble

[NTC]

Access is 'event driven' meaning that it expects a user in front of the screen doing stuff. It isn't an exe running in the background that is going to auto send emails to anyone.

So what you want first is a query/report - that is going to each day give you a list of shipments that are X days old, and the emails of those. And you run that list each day.

As to the email; while it can be automated from Access upon running the list or otherwise triggered by the database user - - if you are not comfortable with code it is really quite simple to just copy the column of emails from a query and paste it into the TO or BCC field of your email system.

Hope it helps a little.

[pbaldy]

I would agree with NTC's "event driven" comments, but you can create a db that does a process like that when it opens and then it closes itself. Then you run that db from Windows Scheduled Tasks on the appropriate schedule. That would be one way to fire off any necessary emails each morning.

[imintrouble]

Thanks both. This was just something I thought I might like to happen to keep the work load off of myself. But I suppose it won't be so bad having to get each address in there manually. Thanks again!

[pbaldy]

As long as the addresses are in the data, you shouldn't have to do anything manually. Here's a start:

http://www.granite.ab.ca/access/email/recordsetloop.htm