Extracting Location info from All Day Event in mailboxes into webpage

Not open for further replies.


Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
We have a requirement to identify where people are working as many of our staff move between offices.

We were thinking about each person setting an All Day event where the location has been set.


A script could then run daily to extract the information for the week on where each person in a division was located

i.e. uses a particular AD group to enumerate through to produce an HTML file such as:

User Monday Tuesday Wednesday Thursday Friday Saturday Sunday

Adams, John London Luton Luton London Luton Home Home

Smith, Mike Paris Chicago Chicago Chicago Chicago Chicago Home


A second HTML file would be set up based on Location, so that the reception team were aware who would be in the office (for fire regulations etc)



Smith, Mike Tuesday Wednesday Thursday Friday Saturday


Adams, John Monday London


Adams, John Tuesday Wednesday Friday


Smith, Mike Monday

Anyone come across this in the past, or could give me some pointers? We are moving everyone onto Exchange/Office10.
Do you need an HTML document? Your plan should work, but you might be able to use Schedule View right in Outlook, especially if the # of people is short (like no more than 10-13). It won't help much with sort by location option though.
Thanks for the reply Larry. We need to track around 150 people as a minimum and needs to use Location, so for example the fire warden can check on a given test that everyone is out..
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
B Extracting email addresses from a folder - how to also get the name of the person the address is for? Using Outlook 5
O Extracting all mail addresses from all folders Using Outlook 10
M Extracting cell data from table Outlook VBA and Custom Forms 2
A Extracting only one recipient from Msgitem.To Outlook VBA and Custom Forms 7
Z Default VBA code for extracting data from email (Outlook) to Excel? Outlook VBA and Custom Forms 1
V Extracting user-defined details from a public folder Outlook VBA and Custom Forms 2
M Oh please read---> Extracting email web leads on to excel spread sheet Using Outlook 3
J Need Help Extracting Email Content into Excel Specifically the Attachment Name Using Outlook 3
E Extracting CC Email Address Using VBA Outlook VBA and Custom Forms 2
K Extracting Calendar information from a OST file? Exchange Server Administration 5
L Location Unsafe Warning for Links Using Outlook 1
K Changing the Deleted Items location in Outlook 2019 Using Outlook 2
T Outlook 365 Search Box reverting to old location Using Outlook 2
C "The linked image cannot be displayed. The file may have been moved, renamed, or deleted. Verify that the link points to the correct file location" Using Outlook 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
S Navigation Pane Location And Options Using Outlook 19
DoctorJellybean Use OST file location for fresh installation? Using Outlook 1
O Calendar - Location: what happens when using my own way of entering locations Using Outlook 1
M Reverting The Outlook Search Box Location (or other undesired additions) Using Outlook 1
T Changing Sent Items location in Outlook 2019 Using Outlook 0
N Free/busy publish at http location does not work Using Outlook 1
L New Location for the Search Bar Using Outlook 6
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
DoctorJellybean Preserve OST file location in new installation? Using Outlook 4
S Moving .OST file location unsuccessful! Using Outlook 6
W Appointment occurrences change the location property Using Outlook 0
A Missing context menu on Location field Using Outlook 2
V Change default default save location to Quick Access Using Outlook 1
T Remove Old Location From Tasks Pane Using Outlook 1
Diane Poremsky Meeting Location Warning Message Using Outlook 0
Kika Melo Change location of Outlook SecureTemporary Files Folder Using Outlook 5
Pierce007 Maps/location in making an appointment Using Outlook 2
J Live Meeting Location populate from body Outlook VBA and Custom Forms 4
K After Carbonite restore pst files are found in a weird location Using Outlook 2
M Save selected email message as .msg file (with user to choose folder location) Outlook VBA and Custom Forms 14
Tech Checkers Make Outlook add Contact Card Address in Location Field based on Appointment Subject Name. Using Outlook 2
moron save as & file location dialog box popup Outlook VBA and Custom Forms 2
H Can't change the location of the Data File (.ost) in Outlook 2013 Using Outlook 2
R Outlook will not send from home location Using Outlook 6
S Workgroup template file location? Using Outlook 2
L Cannot update Location field in Contacts - Runtime Error 438 Using Outlook 0
K Change the default Archive location via GPO in Outlook 2010 Using Outlook 3
P Trying to get 'Calendar Name' to appear like 'Subject' and 'Location' in event Using Outlook 0
S Holidays after 2012 & NOT displaying location Using Outlook 8
C Outlook 2010 - Default PST location Using Outlook 4
M Outlook 2003: Restore location Using Outlook 1
Z Mail delivery location - I think Using Outlook 1
T Location and simple copying of emails and settings, OL 2010 and Win 7 64bit. Using Outlook 3
J Remove location field from displaying Using Outlook 8

Similar threads