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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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