Expense Reports (mailing and access)

I have been asked to keep track of Outside Sales
expense reports. The boss wants a way to organized
these expense reports (weekly) so he dosesn`t have
to do anything.

I invision. two programs. 1 for the boss which to keep track of the 6 salesmen. And 1 for the 6 salesmen to keep track of themselves and allow them to submit through outlook.

Of course information will be stored in access.

Question: How am i going to get weely information to the boss from the guys on the road. Can i use Outlook to do this.? How can i automatically input the information into the bosses database that arrives by outlook??

Any suggestion??

Thanks

Seahag

Couldn't the salesman have a program that creates the data and emails it to the boss? Then the boss can upload the new data into the program that he is useing?

Exported data could be a textfile, or another mdb. Once the data is imported, delete the imported file.

Ya something like that.
I want the boss to get an email saying. So an so has just submitted thier expense reports, Bla bla bla.

How will that email with attachement be opened and updated to the bosse database?

?

Things to consider:

1) Email code.

2) Storage of data to be imported (textfile probaby easiest).

3) The ability of the BOSS, to hit a button to import the attachment data into his viewer)...:D

See my attahments - must have reference to common dialog box to allow user to select attachement, but you will be driving the attchement path when you create it....

And the code for the form (some stuff won't make sense - subject to the app I pulled from). If questions, ask.

The code for the form attached.

Kool
Ok here goes..

I have been looking around.. and it would seem that i will have to rely on Boss to hit button...

How am I going to do that..
Either its access, or text... by clicking on it does nothing..

I need at least for him to click on the attacment and it automatically update his database..


Any suggestion how i can at least do that..

\\
Seahag

So you want to add add-in in Outlook to automate the import. Hell, I'd like to know how to do that to...

I just have user (in your case the BOSS), save it to his MY Docs folder, the use a Coomon Dialog to Browse and select the file...

ie textfile = "Rick Johnson EP Data 03-01-2002.txt"

See what I mean.

(if you figure the Outlook thing out, let me know...)

doe (_:^ ()

:)

I thought it would be easier when i was talking to Him..


I`ll keep at it

Thanks

Seahag