Import Spreadsheet from Outlook Attachment
Posted on 2002-07-24
Can anyone help me with some code that will allow me to save an attachment from Outlook and import it into access?
I'm getting about 30-40 e-mails a day that have a .csv attachment. I want to be able to save this attachment as an excel file and place it in a specified folder. Then move the e-mail into another folder in outlook. The e-mails are filtered into a specific folder when I receive them in outlook. As for importing into access, I've already created something that import the information I need from the excel files in the specified directory that I place it in. If you need anymore info, let me know.