By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

Work order system -email import program

100+
P: 157
Hello!

I am currently designing a work order system for our service department. The system will be a place to se what your task should be for today and a possibilty for users to report task's for our service department.

Example:
John discovers that on of our conveyer belts makes a screeming sound. He goes to his computer and sends a e-mail to service@mycompany.no
This email goes to a server which has access running. This access database uses a mail import module (.mdb) that i have gotten from Fabalou.com.

This import module i want to run with a sleep function that checks the inbox (run the module) every 2 minutes or something.
The problem is that when this module tries to contact the inbox you get a msgbox in outlook that a program wants to access your inbox and you have to approve it. Because of this my hole plan is useless if i cannot get outlook to always accept request from access.

Is there anyone her who have a solution to this. Either to fix outlook or to use a different aproach.
If not i have to install access on all computers which should be able to report errors to the service department so that they can use a standard access form.

Please help a Norwegiean fella :)
May 21 '07 #1
Share this Question
Share on Google+
3 Replies

100+
P: 157
Ok.
I found out that i can use Outlook Redemption to import mail messages from outlook inbox to a table in Access. But this programming is way of my level....

If there is someone here who can help me with an example on how to code a import of new messages from inbox to a table using Outlook Redemption i would appreciate it very much

:)
May 21 '07 #2

NeoPa
Expert Mod 15k+
P: 31,770
I'm sorry Mr Deej.
That link looks like third party software. This is a general Access forum and not a free coding resource. We're happy to provide answers where we can to specific questions. Unfortunately we don't have time (or inclination I suspect) to design anything for you from scratch.
We're about teaching how to fish rather than doing the fishing for you.
Jun 2 '07 #3

P: 4
You can control the security messages with this tool.

http://forum.geniusatwork.nl/topic.asp?TOPIC_ID=145
Jun 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.