Hi Ron,
Thank you so much for getting back to me. I'll try the code out and let you
know how I get on.
P.S I use Outlook
Regards
Chris
"Ron de Bruin" wrote:
Hi Chris
For Outlook see
http://www.dicks-clicks.com/excel/olRetrieving.htm
Or do you use OE?
--
Regards Ron de Bruin
http://www.rondebruin.nl
"ir26121973" wrote in message ...
Hi,
Wonder if somone can help me out please. I am very new to VB, but willing to
learn.
I receive up to 900 emails a day. All have one attachment in a .csv format
and all are attachments are called Ack. I am desperately trying to find some
code where I can automatically take the email attachments without opening the
email and save them to a shared folder where they are saved using the email
subject as the filename.
The problem I have got is that the functionality for using VB in Outlook has
been taken away from the computer system at work so the only VB I can use is
through Excel. Because of this I am not sure whether it i easier to drag and
drop the emails from outlook into the shared folder and then extract from
there.
I really would appreciate some help here, because I am under quite a tight
deadline.
Many thanks in advance
Chris