About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
Using MS Access - Create an Outlook meeting from msAccess 2003
Expert: Rob Henderson - 2/23/2005
Question I have a msAccess 2003 customer data base for my chimney sweeping company. I would like to e-mail an invitation to my chimney sweep, a msOutlook user, to a meeting from msAccess 2003.passing the date an time from the data base to his e-mail address Is this possible? How can it be done?
I have worked with msAccess, SQL and HTML but not much with VB or VBA
Answer Hi
It can be done.
The easiest way is to link a table to your appointment calendar in outlook and then create a form. This is also the most unelegant way as you have no choice over which fields are returned in the table link and also your access interface will not be as good as outlooks'.
The other way is to use VBA automation.
This means that you set a reference in the code to the Outlook DLL and then you create an instance of outlook which you can then work. Doing this allows you to manipulate specific items in outlook.
Be warned though, the Outlook model is reasonably complex and will take a little bit of learning.
If you want to go down this route, read up on automation
