My wife is a substitute teacher and gets emails with her assignment. What she has asked was if there was a way to easily convert those emails to a calendar appt. I did find that I could click on the Meeting button but there's a lot of cutting, pasting,
and date selection that is a bit tedious. Curious if I could use a script to make it more automated.
I'm pretty good with VBA in Excel on Windows, so I'm figuring there's a way to do what I want in VBA, but as (1) I've never used VBA on a mac and (2) never used VBA with outlook, I have no clue where to start.
Any ideas on how to:
- Convert to meeting
- Find line that starts with: "Location:" (ex: Location: WHITE, E. B. ES) and copy the rest of the line to the location block in Capital case (ex: White, E.B. ES)
- Find line that starts with: "Classification:" (ex: Classification: GRADES 1-3) and copy the rest of the line to the Subject block in Capital case (ex: Grades 1-3)
- Similarly parse out start date and end date from the body and enter those dates into the appt
Hoping someone with Outlook VBA skills could help me out.
Thanks!!
Recent Comments