Forum Discussion
create Appointment Item in MS Outlook Calendar from Button in MS Access
Hi,
I am pretty new to Microsoft Access but find it really useful to keep my client contacts info, project info and invoices in line. I am trying to create a new leads database to keep track of my pipeline. I enter new inquiry info into tables using forms. I would then like to create Appointment Item in MS Outlook Calendar from Button in MS Access. It is just a single appointment going to my own calendar, based on filling in a form that look like this (see image below). Most of the information will populate automatically when I enter the EnquiryID, but I would like to enter the date, time and subject and then save it as an appointment into my own Outlook Calendar to remind me to do a follow up call on a certain date. Has anyone done anything similar?
- Hello Julie,
I have done this in Access with Visual Basic for Applications (VBA), but that probably exceeds your scope as you are pretty new to Access. Nevertheless, let me know if you would try to set this up with VBA.
Best regards,
Tieme
- I shared the sample application in a separate topic: https://techcommunity.microsoft.com/t5/access/sample-access-application-for-creating-appointments-in-outlook/m-p/3796114/thread-id/7709
- Thank you so much for this 🙂
- Dear Toeme
Thank you for your reply .
It works
And I was able to add note and full day appointment, not able to work out the chkbox already on outlook though
How can I share the appointment not on mine but on a share calendar?
- Hello Julie,
I have done this in Access with Visual Basic for Applications (VBA), but that probably exceeds your scope as you are pretty new to Access. Nevertheless, let me know if you would try to set this up with VBA.
Best regards,
TiemeHello Julie,
I created an Access application for this, but I can not send Access files through this community. Do you have a regular mail address where I can send the Access file to? Maybe you can send the mail address to me in a direct message.
Short explanation
The application creates an Outlook-appointment on clicking the Add To Outlook button. Below an example of the form:
After filling the form and clicking the button the appointment appears in Outlook:
And if you open the appointment you see the details:
I hope you can incorporate the VBA-code and form functionality of my application into your application. The VBA-code is in the module modAppointment. And in the form you need to connect the click-event of the button to the cmdAddToOutlook_Click subroutine in the VBA-form module (Form_Action).
If this does not work out for you, maybe you could send me your application and I will incorporate the functionality. But that depends on the security policies of your organization.
Good luck and feel free to contact me for any further questions.
Best regards,
Tieme
I am trying to do this as well and the link below does not work anymore. Could you repost the VBA code please? Thank you!
