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

03-12-2012, 01:43 AM	#1
sassora VBAX Regular Joined: Jan 2008 Posts: 201 Kb Entries: 0 Articles: 0	Out of office messages - display team members in office 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
Local Time: 07:21 PM Local Date: 05-20-2013 Location:

03-14-2012, 07:06 AM	#2
JP2112 VBAX Mentor Joined: Oct 2008 Posts: 592 Kb Entries: 1 Articles: 2	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 Regards, JP Read the FAQ Getting free help on the web My website Please use [vba][/vba] tags when posting code
Local Time: 01:21 PM Local Date: 05-20-2013 Location: