SOLVED

create Appointment Item in MS Outlook Calendar from Button in MS Access

Copper Contributor

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?

 

forum question.jpg

13 Replies
best response confirmed by Julie1606 (Copper Contributor)
Solution
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

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

@Julie1606 

 

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:

 

image.png

 

After filling the form and clicking the button the appointment appears in Outlook:

 

image.png

 

And if you open the appointment you see the details:

 

image.png

 

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

 

Hi Tieme,
I have just sent you me direct email.
Thanks,
Julie
Dear Tieme,
I'm working on something similar.
Could you please share your vba code with me. I've sent you a PM with my email address.
Thanks
Dear all can you help me too, I have a series of field already in a schedule table I want to share in a shared outlook calendar
I would love a copy of this as well

@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

I would love to get a copy of this as well...
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?

@Tieme Woldman 

 

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!

1 best response

Accepted Solutions
best response confirmed by Julie1606 (Copper Contributor)
Solution
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

View solution in original post