[spooks]

G'Day everyone,

Firstly, thank you for this super-awesome website. I can spend my whole day trawling through the gems here which make my life so much more easier!!

I have a question:

I am trying to write an Outlook 2007 Macro which has me a bit stumped.

We get a system generated email which tells us which staff is late for which department. The Managers then send an email to their departments only extracting the info from this email.

I have a rule currently set up which dumps this daily email to the "Sick and Lates" folder. I then go there everyday at 9:30 am, copy the names of the guys in my department and send an email to the DL.

I am trying to automate this so that whenever a sick and late email arrives, Outlook will pick up the names of the people in my department only, chuck them in a separate email addressed to a specific distribution list and fire away.

I had a look at other posts but am stumped.....help, please?