Outlook Macro

[fac1987]

Hi

I am relatively new to macros, I was hoping I might be able to get some help on creating a macro. The macro needs to:
- Run when a certain email comes in (Outlook 2007)
- Save all the attachments into a certain folder (there are 13 altogether)
- For 5 of the sheets which contain the word 'XXXX', it needs to consolidate the lists in each sheet into a new single CSV file (list headers same and in same order)
- For another 5 of the sheets which contain the word 'YYYY', it needs to consolidate the lists in each sheet into a single CSV file (list headers same and in same order)
- Save these two new CSV sheets into a completely separate directory with a certain name for each which includes the latest Monday date

As of now, I have set up a macro in outlook to run when an email with certain words comes into my inbox. I would also like minimal intervention so if this entire macro could be run out of outlook, that would be perfect.

This is probably not all that hard, has anyone come across any forums/sites/code that might be able to help?

Thanks in advance

 

[Derek Brown]

Hello and welcome to The Board.
For Outlook help and VBA code examples, have a look at Writing VBA code for Microsoft Outlook
You may also find the following useful:
Automate Outlook - JP Software Technologies