Hi,

Here's the situation, I have five people in my team and when I am out of office I like to list contact details of team members that are in the office.

I have used excel VBA before but I don't know how to go about this. The solution would produce an out of office message with only team members that are in the office that day, according to their outlook calendars.

I hope you can help.

R