Need help automailing

  • Thread starter Thread starter Louis Herndon
  • Start date Start date
L

Louis Herndon

Hello,

Ill be very specific, I am new to Access, but am learning
quickly. I do not however, know Vbasic very well. Here
is my problem, I have made a fairly simple database for
work. I have created a form we use to basically input
information on laptops, ie: Users name, Laptop
brand/model, date serviced, user's email address, and
comments section to describe what was done. We wish to
automate this application, so that users are emailed 60
days after the last service date, based on the service
date on the form and their email address in the form. How
specifically would I do this? Do I have to use Vbasic to
script it, or can I set it up through Form design?

Any help would be appreciated.
 
This might not be the smoothest way but here's how I do it....

1) Create a database that links to the tables in your current one
2) Write a query that gives you the results you want to email
3) Write a report based on that query so it looks pretty
4) Write a macro and use the 'sendobject' function and fill in the details of who to send it to.
5) Write as many of those as you need (queries, reports) for each person who is to get one
6) Write a macro called autoexec that runs your queries (this macro runs automatically when the database opens) and you can use the QUIT function in the macro steps to shut the database down when it's through
7) Use a timer program to fire off this database whenever you need it run (hourly, daily, weekly, monthly, etc...) http://www.splinterware.com/products/wincron.htm is absolutely brilliant and free

There are a few drawbacks to this method that I have yet to solve....1) it will email out blank reports, 2) requires unique queries and reports for each and every person you want to email it to (if the reports are different).

This isn't the prettiest method but it works great and my users love it !!!!
 
Back
Top