MS Access vs MS Outlook

[=?iso-8859-1?Q?St=E9phan_McLaughlin?=]

Good morning

I'm a manager of a property section and part of my team
responsabilities is to respond to work-order request from
users (eg.: roof is leaking ... please save us!). To keep
track of the work orders we currently use an custom base
MS Access application that was designed for our us.

As MS Outlook is our central communication system, I
wanted to improve a little this system and I was
wondering if I could use MS Outlook forms to feed in my
MS Access database and then, to automatically dispatch
task to my staff from the work order request?

I used to programmed in another life, I did VBA for Excel
and Access, so I have basic knowledge of these things...
where can I start to find an answer to this potential
project?

Anyone can help?

Regards

Stéphan

 

[Arvin Meyer]

Working from Access to Outlook is relatively easy. Outlook to Access is more
difficult. I have several demo databases on my website which demonstrate
connecting Access to Outlook, including one similar to the one illustrating
my last article in Advisor magazine.

http://www.datastrat.com/Download/OutlookAppointment.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access


Good morning

I'm a manager of a property section and part of my team
responsabilities is to respond to work-order request from
users (eg.: roof is leaking ... please save us!). To keep
track of the work orders we currently use an custom base
MS Access application that was designed for our us.

As MS Outlook is our central communication system, I
wanted to improve a little this system and I was
wondering if I could use MS Outlook forms to feed in my
MS Access database and then, to automatically dispatch
task to my staff from the work order request?

I used to programmed in another life, I did VBA for Excel
and Access, so I have basic knowledge of these things...
where can I start to find an answer to this potential
project?

Anyone can help?

Regards

Stéphan

 

[Guest]

-----Original Message-----
Working from Access to Outlook is relatively easy. Outlook to Access is more
difficult. I have several demo databases on my website which demonstrate
connecting Access to Outlook, including one similar to the one illustrating
my last article in Advisor magazine.

http://www.datastrat.com/Download/OutlookAppointment.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access


"Stéphan McLaughlin"

 

[Stephan McLaughlin]

Super ... and thak you very much

It shows me the potential and that this could work ...
most probably.

Would you have an example of the opposite, a simple
Outlook e-mail user form than upon reception to a
specific e-mail address, automaticaly saves the info it
contains in a specific .mdb table?

Anything would help

Best regards

Stef

 

[Arvin Meyer]

It is possible, but I've not had good luck with it. Outlook can run a
VBScript in response to a very few user actions on a form, but the only
actions that happen unattended use the Exchange Event Service. That service
has been very finicky on Exchange 5.5 servers and not reliable at all on
later versions. Perhaps if you asked one of the Outlook MVPs, in an Outlook
newsgroup, you might get a better answer. In particular, Randy Byrne, Susan
Moser, and Diane Poremsky all have good coding skills in that area and may
have already written something that you can adapt.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Super ... and thak you very much

It shows me the potential and that this could work ...
most probably.

Would you have an example of the opposite, a simple
Outlook e-mail user form than upon reception to a
specific e-mail address, automaticaly saves the info it
contains in a specific .mdb table?

Anything would help

Best regards

Stef