Email Notifications

[spcscooter via AccessMonster.com]

I am not sure how to proceed with this so bare with me. I have created an
Access 2K3 Database and I don't know much about VBA coding. But here is what
I am trying to accomplish. I have a query that gives me result of 90 days
after the date that a technicians 1st class starts. I need to automate an
alert / email message that 90 days has passed. This mesaage needs to be sent
to the powers to be. Can anyone help me with this issue. I have looked into
books and am unable to come up with something that I know what to do with.

Thank you for the help,

 

[Guest]

Take a look at

http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

for the code to send emails using Outlook.

Also, if you want to simply send a query,report it is simpler to use the
DoCmd.SendObject method.

you could set up your db to execute your query when it is opened and send
the email if it returns any results. It would be important to have a table
to log when an email is sent to stop it from sending multiple email the same
day if you open your db several time thoughout the day.

If you require more detailed help just reply back to this email and we will
further assist you with this one.

Daniel

 

[spcscooter via AccessMonster.com]

Would I use a Macro or Module to use the DoCmd.SendObject method? Sorry if I
seem a little lost I have never done the whole email thing in Access before.

Take a look at

http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

for the code to send emails using Outlook.

Also, if you want to simply send a query,report it is simpler to use the
DoCmd.SendObject method.

you could set up your db to execute your query when it is opened and send
the email if it returns any results. It would be important to have a table
to log when an email is sent to stop it from sending multiple email the same
day if you open your db several time thoughout the day.

If you require more detailed help just reply back to this email and we will
further assist you with this one.

Daniel

I am not sure how to proceed with this so bare with me. I have created an
Access 2K3 Database and I don't know much about VBA coding. But here is what

[quoted text clipped - 5 lines]

Thank you for the help,