Automated Requests in Access

[Guest]

Hi

I am a Project Manager and would like to start using MS Access to manage
projects. My question is this: If I have a project start date, of say May 1,
I normally arrange a meeting with business partners a week before to discuss
the content of the project in hand. Is it possible to get MS Access to
automate the task of sending a meeting request to the parties I will of
indicated?

Also, on completion of a project, I send an email to all indicated parties
stating that the project has been completed and ready to implement. Would it
also be possible to generate an automatic email on completion, say after I
have checked a 'completed' box?

Just wanted to check a few things before I spend a lot of time setting up a
database. I want to know that it will be able to cope with what I want it to
do in the future.

Thanks

Brad

 

[Guest]

Hi Brad - yes Access is fully capable of doing what you want. Even without
learning coding (which of course is much more flexible but takes lots of time
and practice) you can automate your DB to send off an E-mail (I assumed that
was what you meant by a meeting request). You would set up a Macro to run
when a particular 'thing' happened; ie when the system opened, when the user
clicked a button, when a form opened. Same when project is finished - click a
button, fill in a field, type in a piece of text - it's up to you when, and
the email is sent. I have several systems which do similar things. Good luck
and let us know if you need help with any of it.

Yours -- Dika

 

[Guest]

I actually meant a meeting request, like the type you get in Outlook, rather
than just an email. Would this work too Dika?

Brad

 

[Guest]

Not with a simple macro so would take a little longer to set up and you would
need to learn VB coding. Yrs - Dika