SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2425085%22%20slang%3D%22en-US%22%3Ecreate%20Appointment%20Item%20in%20MS%20Outlook%20Calendar%20from%20Button%20in%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2425085%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20pretty%20new%20to%20Microsoft%20Access%20but%20find%20it%20really%20useful%20to%20keep%20my%20client%20contacts%20info%2C%20project%20info%20and%20invoices%20in%20line.%20I%20am%20trying%20to%20create%20a%20new%20leads%20database%20to%20keep%20track%20of%20my%20pipeline.%20I%20enter%20new%20inquiry%20info%20into%20tables%20using%20forms.%20I%20would%20then%20like%20to%20create%20Appointment%20Item%20in%20MS%20Outlook%20Calendar%20from%20Button%20in%20MS%20Access.%20It%20is%20just%20a%20single%20appointment%20going%20to%20my%20own%20calendar%2C%20based%20on%20filling%20in%20a%20form%20that%20look%20like%20this%20(see%20image%20below).%20Most%20of%20the%20information%20will%20populate%20automatically%20when%20I%20enter%20the%20EnquiryID%2C%20but%20I%20would%20like%20to%20enter%20the%20date%2C%20time%20and%20subject%20and%20then%20save%20it%20as%20an%20appointment%20into%20my%20own%20Outlook%20Calendar%20to%20remind%20me%20to%20do%20a%20follow%20up%20call%20on%20a%20certain%20date.%20Has%20anyone%20done%20anything%20similar%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22forum%20question.jpg%22%20style%3D%22width%3A%20993px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287094i9E7E890E09A7A85C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22forum%20question.jpg%22%20alt%3D%22forum%20question.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2425085%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2425603%22%20slang%3D%22en-US%22%3ERe%3A%20create%20Appointment%20Item%20in%20MS%20Outlook%20Calendar%20from%20Button%20in%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2425603%22%20slang%3D%22en-US%22%3EHello%20Julie%2C%3CBR%20%2F%3EI%20have%20done%20this%20in%20Access%20with%20Visual%20Basic%20for%20Applications%20(VBA)%2C%20but%20that%20probably%20exceeds%20your%20scope%20as%20you%20are%20pretty%20new%20to%20Access.%20Nevertheless%2C%20let%20me%20know%20if%20you%20would%20try%20to%20set%20this%20up%20with%20VBA.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3CBR%20%2F%3ETieme%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2428096%22%20slang%3D%22en-US%22%3ERe%3A%20create%20Appointment%20Item%20in%20MS%20Outlook%20Calendar%20from%20Button%20in%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2428096%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131546%22%20target%3D%22_blank%22%3E%40Tieme%20Woldman%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EI%20would%20really%20appreciate%20it%20if%20you%20could%20set%20this%20up%20with%20VBA.%20I%20have%20tried%20myself%20by%20cutting%20and%20pasting%20similar%20codes%20I%20have%20found%20without%20success.%20I%20have%20not%20used%20VBA%20before%20and%20may%20have%20missed%20some%20of%20the%20main%20steps.%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3EJulie%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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

4 Replies
best response confirmed by Julie1606 (New 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