VBA Save Outlook Meetings to Access

  • Thread starter Thread starter Bryce
  • Start date Start date
B

Bryce

I am keeping track of who is taking what classes in Access. The people are
invited to class via an Outlook Calendar meeting - I add them as recipients.
I don't want to have to do double-entry however in my Access database as to
who has been invited to what class. Any ideas?
 
Have you tried importing or linking your Outlook Calendar into your Access
database? The To field will contain a delimited list containing either the
name, e-mail address, or name and e-mail of the recipients you sent the
Meeting Request to.

--
Eric Legault [MVP - Outlook]
MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007
& WSS 3.0 Application Development)
Collaborative Innovations
NEW! -> Try Picture Attachments Wizard 2.0 For Microsoft Outlook <-
Web: http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault
 
I would approach this from the Access side of the equation as Access can
generate Outlook items via code, including Meeting requests and what not.
Roughly, you would set up a new Training class in Access ("Orientation"), add
the schedule ("Monday, June 6th - Tuesday June 10th), add the attendees
("John, Mary, Bill the Cat") and then hit a button to generate the meeting
request. You would need some sort of status to track whats going on such as -
Scheduled, Invited, Confirmed, Completed, Cancelled, Rescheduled. The status
could be updated as you receive the notices wether in your Outlook inbox as
("Meeting Request Accepted, Declined"), voice mail or class roster.
 
Back
Top