MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMS SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old December 10th, 2004, 09:32 AM
confuzed2xover confuzed2xover is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2004
Posts: 185 confuzed2xover User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMS SQL Development > MS SQL 2000 & Outlook 2000 Question


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway