Thread: Saving Attachments Automatically with Unique Filenames

Help!! I have a major panic on my hands.

An HR member of staff sent out a survey spreadsheet for other members of staff to complete and return to a generic email address, which they duly did. He assured us that he had everything in hand and that we would have the results of the survey by the end of the week.

Well, it's now Thursday and he has just been signed off work for the next 3 weeks and we need this information by Monday at the latest.

Essentially, I need some VBA that I can stick into Outlook that will save all the attachments on the 2000 odd emails we have in a named folder, into a folder on a designated PC (mine, actually).

The problem is that over half of the attachments have exactly the same name, so I need a way for each attachment to be saved with a unique filename (maybe with a number after each one) so that they don't overwrite each other.

I've searched, and there are a few requests for similar VBA on these boards, but none that appear to do exactly what I need, and I'm not adept enough with VBA (to be honest I didn't even know Outlook used it) to be able to make complicated adjustments.

Can anyone point me in the right direction? A previous thread with instructions written in crayon as to how I would adapt it to my needs would be perfect.

Thanks

Edit: Forgot to mention that I'm using Outlook 2003 (I know, cutting edge).

http://www.office-addins.com/-outloo...processor.html