VBA Save Outlook Meetings to Access

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?
 
G

Guest

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
 
D

dch3

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