PDA

View Full Version : Out of office messages - display team members in office



sassora
03-12-2012, 01:43 AM
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

JP2112
03-14-2012, 07:06 AM
These threads might offer some pointers:

http://www.vbaexpress.com/forum/showthread.php?t=26875
http://www.vbaexpress.com/kb/getarticle.php?kb_id=1065