Skip to content

Instantly share code, notes, and snippets.

@talkingmoose
Last active April 5, 2024 22:09
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save talkingmoose/771904e739c6277b61950185f85ad188 to your computer and use it in GitHub Desktop.
Save talkingmoose/771904e739c6277b61950185f85ad188 to your computer and use it in GitHub Desktop.
AppleScript to look up an Exchange user's free/busy time using Outlook for Mac
tell application "Microsoft Outlook"
query freebusy exchange account 1 for attendees {"bill@talkingmoose.net"} range start time date "Thursday, September 8, 2016 at 12:00:00 AM" range end time date "Friday, September 9, 2016 at 12:00:00 AM" interval 60
end tell
@talkingmoose
Copy link
Author

talkingmoose commented Sep 8, 2016

  1. Replace my email address for yours. Use commas to separate multiple email addresses.
  2. You can either use AppleScript's long form of the current date and time, use (current date) for right now or (current date) + 86400 for 24 hours from now. Substitute 86400 for number of seconds in the future.
  3. Set the interval to 60 to get back results for every 60 minutes between the start time date and end time date or enter any other number.
  4. Results are returned as Subject, Location and Status as an array. Example output:

{"bill@talkingmoose.net", "2016-09-08 00:00:00 -0500", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "Remote Session", "Phone", "busy", "Remote Session", "Phone", "busy", "Remote Session", "Phone", "busy", "Remote Session", "Phone", "busy", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free", "", "", "free"}

Removing brackets and substituting commas with returns yields:

"bill@talkingmoose.net"
"2016-09-08 00:00:00 -0500"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
"Remote Session"
"Phone"
"busy"
"Remote Session"
"Phone"
"busy"
"Remote Session"
"Phone"
"busy"
"Remote Session"
"Phone"
"busy"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"
""
""
"free"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment