Retrieving work week (start/end times) from outlook with VBA

Status
Not open for further replies.
A

a2VyXzAx

I've searched (object browser, help file, google), but no joy.

I'm pulling certain appointments (based on the contents of the subject line)

and I need to differentiate between any partial or full appointments that are

within the user's workday, and partial or full appointments that are outside

that user's workday (for the partials, I'll have to calculate the number of

hours that are actually within the workday). Different users have different

start and end times set on their calendar.

I haven't been able to find the part of the object model to show the

individual user's workday- can anyone point me in the right directions? Once

I have that I can calculate backwards to get the duration within the workday,

unless there is an easier way to do this somehow.

Thanks!

Keith
 
Those settings are stored in the registry, at

HKCU\Software\Microsoft\Office\11.0\Outlook\Options\Calendar (11.0 is for

Outlook 2003, for Outlook 2007 it's 12.0, etc.).

The values are stored as DWORD's, you will have to reverse engineer what the

meanings are, I'm not sure how they are interpreted by Outlook. Make changes

in the Outlook settings and see which registry values change and in what way

depending on the settings you change.

 
:( I think that kills my project.

I have code that pulls any appointment which includes "vacation" in the

title, and uses that to build a department vacation calendar. The problem is

that some folks use recurring appointments (monday, but recur 3 times) or

long appointments (start Mon 7am, ends Thurs 3pm). Right now I'm trying to

set it up so that a person with shared viewing permissions can run the

program for our whole department, so we don't have to bug each person to run

the code on their PC. In my example, the Thurs 3pm could mean 8 hours of

vacation if their worksday ends at 3pm, or it could mean 6 hours vacation, if

their workday ends at 5pm. Eventually we'll have people in another time

zone, and that will make it even tougher to figure out.

I'm surprised, because I would have thought that it would be useful

information to have available to others who are scheduling appointments. If

I'm scheduling an appointment with someone on the other coast of the US, or

someone in Europe, it sure would be nice to see their workday (other times

greyed out as unavailable) so that I could be respectful of their schedule.

Maybe that will be in Office2010...

Thank you,

Keith
 
I don't think it will be in Outlook 2010.

I really don't see the problem. All it takes is a number of changes to the

work week settings, saved from Outlook, with checking the registry each time

to begin to see what patterns there are for the relevant settings. A

registry monitor set to filter on changes to only that registry key will let

you observe the results of every change. Then you would know what the

settings are, what they mean and how to work with them. Maybe a half day's

work at most.

 
I'm flattered by your estimation of my programming skills ;-)

I'd be willing to learn how the registry setting works- the roadblock I was

referring to is that we wanted to set this up so that one person (who had

view-only permissions to everyone's calendar) could update the data from

everyone's calendars from the one PC. If the workday settings are on each

individual PC/Registry, then that one 'administrator' won't have access to

them.

I think the intermediate solution would be to have each person document

their work hours manually in my output Excel file, and have the code check

each vacation appointment against the work hours for that employee. Then the

one adminstrator can pull the actual calendar contents from there out.

Best,

Keith
 
I didn't know how to do the registry monitor, but using your directions for

where to look in the registry, it was simple- posting here for future

searches on this topic.

Both the start and end times (Dwords) are hex representations of the number

of minutes into the day. So 7am = 7 hours x 60 minutes = 420 minutes; the hex

representation of 420 is 1a4. 6pm = 18 x 60 = 1080 minutes; the hex

representation is 438. Fortunately Excel has built-in tools to make the hex

conversion.

Of course, now that I'm thinking about it, that's only the final answer for

the local staff (people in the same time zone). I need to do some research on

how time zones will play into this as well...

Best,

Keith
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
D Retrieving Tables from outlook to excel Using Outlook 14
S Retrieving Deleted Outlook Contacts Using Outlook 2
R Outlook 2013 stalls when retrieving from Frontier POP3 Using Outlook 3
F Retrieving old BCM data BCM (Business Contact Manager) 5
J ModefiedForm page issues 1)retrieving available size of Modifiedfo Outlook VBA and Custom Forms 3
A Retrieving CalendarView for Outlook 2003 Outlook VBA and Custom Forms 4
R Retrieving email item Outlook VBA and Custom Forms 5
L Retrieving the DisplayFormat for a UserProperty using VB Outlook VBA and Custom Forms 3
S Change "This Week" flag start date behavior Using Outlook 1
S Outlook 2016 Arrange tasks by date, additional custom sorting, but still use friendly terms like Today, Tomorrow, This week? Using Outlook 1
P Outlook for Mac - emails are not sent out beginning last week Using Outlook 1
C Shading every other week on monthly calendar Using Outlook 4
C Calculating Week Number into a TextBox Outlook VBA and Custom Forms 0
R Week numbers for the month in outlook Using Outlook 1
Diane Poremsky Print Monthly or Work Week Calendars Using Outlook 0
P printing weekly calendar in Outlook 2013 cuts days of week off Using Outlook 1
A Calendar List View Showing Week Number Using Outlook 1
Diane Poremsky Print Monthly or Work Week Calendars Using Outlook 0
P Possibility to create a calendar button "remaining week"??? Using Outlook 3
J Indexing - one user a week - indexing breaks. Using Outlook 1
A Creating rule to create week folder and transfer mail using alert Using Outlook 3
Edaniels Adding Week Number on Calender Using Outlook 2
D 2 Week Delayed Message Using Outlook 7
P Printing calendar (work week) with numerous (i.e. >7) all day events... Using Outlook 3
M Rules - daily status (email) doesn't change much daily, save 1 per week how? Using Outlook 1
P Setting Calendar View to Day/Week or Month Using Outlook 2
G how to change default calendar view to show this week and future weeks? Using Outlook 1
J Ho do I hide the week number on the Calendar Printing Assistant template Using Outlook 4
A Delete all appointments on calendar for week of holiday / annual leave Using Outlook 1
M Display time in an appointment in week or dayview Using Outlook 1
G Printing week with day name Using Outlook 4
C Print only work week Using Outlook 3
R Outlook Web App - calendar week number is incorrect Exchange Server Administration 6
B How can I see the week number in my calendar ? Using Outlook 3
Fozzie Bear Calendar Events created on iPhone have suddenly start sending invitations to attendees Using Outlook 2
D Unable to change AppointmentItem.Start property Outlook VBA and Custom Forms 3
R unable to filter tasks when start date is on or before today Using Outlook 3
O Outlook 365 - Gmail and Outlook: how to force Outlook to start up in Gmail? Using Outlook 2
Witzker HowTo start a macro with an Button in OL contact form Outlook VBA and Custom Forms 12
W Recurrence: delete older occurrences / change earliest start time Outlook VBA and Custom Forms 0
V Change start time based on message duration Outlook VBA and Custom Forms 2
A End-time meeting reminder (or "negative" time relative to the meeting start time) Using Outlook 1
N Multiple instances of Outlook on Start Menu Using Outlook 2
P Automate Outlook Start - No Active Explorer Object Found Using Outlook 10
P Outlook 2016 won't Start Using Outlook 3
M Outlook 2013 fails to start -- missing WindowsCodecs.dll error Using Outlook 3
O Outlook 2016 crashes at start Using Outlook 14
S Calendar loops when clicking on calendar link to start it Using Outlook 1
L set task reminder date to same as start date (without affecting due date) Using Outlook 0

Similar threads

Back
Top