Hi everyone,
I have a macro that processes a bunch of files received every day on email that I have saved into a certain folder.
What would be very cool though is if when the macro starts the first thing it does is go to Outlook, go to an email folder where all these messages are received and save the attachments for me.
This would save hours of arsing about!
Is this something Excel VBA can do?
Or should I be looking at some Rules, VBA, whatever else in Outlook instead?
Any help, very gratefully received as always.
I don't really know where to begin on this one!
Thanks
AJ
P.S. Office 2000 on Win2K (incase that has any bearing on the answer)
I have a macro that processes a bunch of files received every day on email that I have saved into a certain folder.
What would be very cool though is if when the macro starts the first thing it does is go to Outlook, go to an email folder where all these messages are received and save the attachments for me.
This would save hours of arsing about!
Is this something Excel VBA can do?
Or should I be looking at some Rules, VBA, whatever else in Outlook instead?
Any help, very gratefully received as always.
I don't really know where to begin on this one!
Thanks
AJ
P.S. Office 2000 on Win2K (incase that has any bearing on the answer)