
December 10th, 2004, 09:32 AM
|
|
Contributing User
|
|
Join Date: Apr 2004
Posts: 185
Time spent in forums: 1 Day 5 h 45 m 53 sec
Reputation Power: 5
|
|
|
MS SQL 2000 & Outlook 2000 Question
I am trying to automate a process that is currently being done manually. I know there is informaiton on the web about how to do this or bits and pieces that I can learn from to build a full solution for what I need, but I cannot seem to locate any of them right now.
If you have any suggestions on how to locate the info I seek, thank you.
Here is what I currently do:
My customers send me data via email in excel format. I then upload it for them into my SQL 2000 db, because many do not want to take the time to upload it themselves via the FTP we have provided them. A .exe we wrote then takes it and imports the data into the tables based on the "Uploaded" customers ID at a predefined scheduled time.
Here is what I am trying to do:
I want to set up MS Outlook 2000 on my server. Set up a dedicated inbox for my customers to send me their files to. Have a VBScript or something on a scheduler, read that inbox, strip the attachment, import it into the "Uploads" table and get it ready for the .exe to run and import. I am also trying to get it to read the email address it came from, match it with the customers table, so it can associate that file with that customer.
Now I know this can be done eaisly, but I am stummped on where to start. I am unsure how to go about reading the Outlook inbox and get it to the SQL table and ready for import.
Any ideas on what I should be searching for to find any ideas, commands, sample scripts, programs, etc that can accomplish something like this?
Thanks for your help in advance.
|