问题 提问于 2014年2月1日
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!!
撰写回答