Importing delimited text files to SQL with Outlook 2000 VBA

[Craigieboy]

Hello everyone!

I really, really need help! I would like to import/populate a SQL database with a delimited text file. The text file is delivered to Outlook 2000 as an attachment. Right now I have been able to save the attachments to an area on my hard disk, move the email to a folder in my Inbox and make the connection to the database.

Does anyone have any VBA code that will take each attachment (whatever the filename) and automatically import it into SQL - without any human intervention?

Any help or pointers in the right direction would be greatly appreciated!.

Many thanks in advance.

Craig

 

[Guest_imported]

are you automatically saving attachments as they come in? I am trying to save attachments based on subject / From fields to a different folders on my hard drive.

I really need your help of how you did the routine.


thanks