I did a similar thing recently, and because of the problems, I went for a 2
stage approach.

Stage 1, go through the shared folder and output attachments to a windows
folder.
Stage 2, process the windows folder file by file.

I have a workbook handy that does the first part, but it is a bit too much
code to post here. Drop me your email address if you want a copy.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cjneth" wrote in message
...
I can create an e-mail with VBA code. But is it possible to get some code
that will go to a particular shared folder in outlook and then go through
each mail and open the attached file and copy a range of data? To then
move
onto another folder and do the same.
Or would it be easier to get the code to save the attached files to a
folder
and then extract the data?