Auto-Download two text files from a daily email and upload into my DB

[athyeh]

Hi Folks,

Everyday I receive an automated email that contains text files attached to it, everyday I download the files into a folder on my area drive, open my Access DB, and append the records into my DB. Is there a way to automate this entire process?

Thanks,



Tony

[rpeare]

you can retrieve information from outlook objects does the email you get every day have some sort of identifying string you can look for? Either in the subject, body or name of the attached file?

[pbaldy]

I do a number of these, as we receive data from several vendors via email. I started with this:

http://www.thatlldoit.com/Pages/howtosarticles.aspx

the section on Saving an Email Attachment. Within the code that saves the attachment, I call a separate function to import the file into my db.

[athyeh]

you can retrieve information from outlook objects does the email you get every day have some sort of identifying string you can look for? Either in the subject, body or name of the attached file?

Yes, in the Subject Line: "Volume" and also the attached file names.