Ron,
I've tried the coding and it works great.
The only problem is that this code just moves the email within outlook. I
really need the code to find the attachment and save it to a folder on my Z
drive at work i.e out of Outlook completely. As it saves the email I need the
attachment to be saved adding something unique to the filename because when I
receive the emails the attachments are all called the same.
The other option I see I have is to drag and drop the emails into my Z drive
then then automatcially strip the attachments out as explained above.
Any Ideas?
Thanks and 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