storing photos from email

[ventinc]

I run a service business where our field employees take digial photos of their job and email them to me. Is it possible to run a script to automatically store the photos in a database? If it is and each photo is identified by its customer number and date is it possible to have it store in the customers database for that service date. so customer number 555 for 12/15/01 photo would read 555121501.jpg. is it possible to sepatate this out? The customer number is a 1 to 4 digit number. What should I do to the photo before putting in the file. Do most people just use a reference in their database or actually store the photo there? ANy help would be greatly appreciated.

[ December 19, 2001: Message edited by: Kathryn ]