MS Outlook 2007 - macros for handling files
 

Just a question I want to throw out there for any Outlook gurus:

I receive 4 emails per day which each contain and Excel 2007 document of the same layout.

Currently I have to manually open each email, and copy/paste the Excel documents into a single file.

I am looking for a way that I can automate this, within Outlook. Is there a way to build a macro in Outlook to take these four files and merge them or concatenate them or append them to one of the files, to create a single consolidated one?

Yes

---------- Post added at 09:12 PM ---------- Previous post was at 09:06 PM ----------

Scripting and macros in Outlook have been limited from what they were capable of in the past.
Since both Outlook and Excel use VBA for scripting then there is a possibility that this can be done in a single script. Otherwise you should be able to do this in 2 steps, where a macro in Outlook saves the attachments and then a WSH script that combines the Excel files.

Yours
ZB