Send 4 people copies of each other'snext day's schedule each after

G

Guest

I am looking for a better solution to the following Outlook/Exchange problem.

At the end of every workday I ( you can call me user1 ), need to send my
boss ( let's call him manager1 ) and three other managers ( let's call them
manager2, manager3, and manager4 copies of each others calendar for the next
day.

--- Here is what I do currently.
I have access to all the 4 manger's callendars in my outlook and I display
them side-by-side. I minimize my task bar at the bottom of my screen and my
folder navigation on the left and do a print-screen. I then address an email
to a distribution list that contains the 4 manager's email addresses and
paste the screen shot into the body of the email and send it out.

---- Here is what's not so great and what I'd like to improve.
Sometimes the manager's can't quite make out the appointments of other
managers because the screen shot of the 4 side-by-side calendars clips the
contents of appointments, and also if the days are packed with a lot of
appointments I can't quite get the entire day vertically in the screen shot.

---- Suggestions or solutions wanted.
I have received one suggestion: that I add to the screen shot of the 4
calendars side-by-side, attachments of individual screen shots for each of
the 4 managers; which obviously whould show the appointments in a larger
space and more clearly. Is there a way to speed this up with some kind of
macro or VBA that's not that big a deal? ... or is there some much simpler
solution that I am overlooking. Is there a way to quickly convert a single
day's calendar to an image or Word document - I have seen Word temples for a
week and a month, but not for a single day.

If VBA is the answer, how big a job would this be for an expert, or for a
beginning VBA hacker, what book or samples code would be good to look at.
 
S

Sue Mosher [MVP-Outlook]

The VBA code sample at Looking at a search folder with MFCMAPI or Outlook Spy is instructive in this area; the search rules that it uses for a "Send To = (e-mail address removed)" type search are quite complex.
shows how to create a mail message with your own calendar for a given day. To do the same with someone else's calendar, you'd use the Namespace.GetSharedDefaultFolder method instead of GetDefaultFolder to get their Calendar folder. All these methods are documented in Outlook VBA Help.

If you're new to Outlook VBA macros, these web pages should help you get started:

http://www.winnetmag.com/Articles/Index.cfm?ArticleID=21522&pg=1
http://www.outlookcode.com/d/vb.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top