Extracting Location info from All Day Event in mailboxes into webpage

Status
Not open for further replies.

davidgadd

Member
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.

all-day-event.jpg

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

Etc.

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)

Location

Chicago

Smith, Mike Tuesday Wednesday Thursday Friday Saturday

London

Adams, John Monday London

Luton

Adams, John Tuesday Wednesday Friday

Paris

Smith, Mike Monday

Anyone come across this in the past, or could give me some pointers? We are moving everyone onto Exchange/Office10.
 

larry

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
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.
 

davidgadd

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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..
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Status
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
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
I 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
Fozzie Bear Wishlist To be able to add a local folder or network share location in foldern view Outlook Wishlist 1
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
D Junk Mail location Using Outlook 1
J Move PST /changing default location in Outlook 2007 or 2010 64b on W7 64bit Using Outlook 2
G Pop up information location issue Using Outlook 4
C Multiple Locations in Calendar not showing 2nd location in invite Using Outlook 2
J .bcm file location BCM (Business Contact Manager) 1
S New Outlook Distribution List Location Outlook VBA and Custom Forms 2

Similar threads

Top