I have no idea if this is possible but if someone can help me it would be brilliant!

Can you export the information from multiple excel attachments from multiple emails in outlook (all with the same field headings) into one document (with the same headings)?

I receive loads of emails everyday and it would be amazing if I could just run a script that extracts the data and dumps it into the designated document.

Please help!!

Thanks

Hi
there seem to be a lot of solutions on the net.
Maybe this one works for you

__________________
Happy with the answer ? Click on the scale to improve rep -A message to cross posters

Hi,

Thanks for your suggestion,

Had a look at your link. It allows the user to save the attachments automatically however what I need is to be able to extract the data from within the excel document (attachment) into another excel document with the exact same field headings.

If you have any more suggestions they will be greatly appreciated

You can try this add-in
http://www.rondebruin.nl/merge.htm

Thanks, that works perfectly!

You are a life saver