MS Outlook 2007 - macros for handling files - Tilted Forum Project Discussion Community

Leto · 08-18-2010, 05:18 AM

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?

Zweiblumen · 08-18-2010, 01:12 PM

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

08-18-2010, 05:18 AM	#1 (permalink)
Leto Junkie Location: The Danforth	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? __________________ 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

08-18-2010, 01:12 PM	#2 (permalink)
Zweiblumen Insane Location: at home	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