Jun 07 2021 11:22 PM
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?
Jun 08 2021 02:03 AM
SolutionJun 08 2021 11:54 AM
Hi @Tieme Woldman ,
I would really appreciate it if you could set this up with VBA. I have tried myself by cutting and pasting similar codes I have found without success. I have not used VBA before and may have missed some of the main steps.
Best,
Julie
Jun 08 2021 11:37 PM
Hello 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
Jun 10 2021 05:39 PM
Oct 09 2021 12:58 PM
Feb 06 2022 04:49 AM
Dec 14 2022 09:08 PM
Apr 05 2023 12:28 PM
@Tieme Woldman
Hi Tieme,
I would love to see that code as well. It would be very helpful. I have been getting a Run-time error of 438 with the code I have been using.
Thank you,
Sammy
email address removed for privacy reasons
Apr 11 2023 07:07 PM
Apr 14 2023 05:05 AM
Apr 14 2023 11:29 AM
Apr 17 2023 12:57 PM
Oct 25 2023 07:20 AM
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!
Jun 08 2021 02:03 AM
Solution