Leto

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?

__________________
You said you didn't give a fuck about hockey
And I never saw someone say that before
You held my hand and we walked home the long way
You were loosening my grip on Bobby Orr

http://dune.wikia.com/wiki/Leto_Atreides_I

Zweiblumen

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

__________________
Sodomy non sapiens. : I'm buggered if I know