Hi Nigel
See Dick's site for a example
http://www.dicks-clicks.com/excel/ol...ve_Attachments
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Nigel RS" wrote in message ...
I have an Excel application that sends email with workbook attachment via
Outlook, the target users Outlook has a rule that moves these emails into a
specified folder.
What I now require, from within Excel if possible, is to copy these email
attachments to a windows directory and to read them sequentially into Excel.
I know how to process the files once they are in a windows directory but not
how to get them out of Outlook?
Cheers
Nigel RS