MS Access run process in outlook 2003

I need a (Hopefully) VBA process to insert an appointment into Outlook.

We're using Office 2003

A link on the process is fine
lrbristerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Randy DownsConnect With a Mentor OWNERCommented:
Try this

http://msdn.microsoft.com/en-us/library/office/aa210899(v=office.11).aspx

Using the AppointmentItem Object
Use the CreateItem method to create an AppointmentItem object that represents a new appointment.
The following Visual Basic for Applications (VBA) example returns a new appointment.
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olAppointmentItem)
            
Use Items (index), where index is the index number of an appointment or a value used to match the default property of an appointment, to return a single AppointmentItem object from a Calendar folder.
You can also return an AppointmentItem object from a MeetingItem object by using the GetAssociatedAppointment method.
Remarks
If a program tries to reference any type of recipient information by using the Outlook object model, a dialog box is displayed that asks you to confirm access to this information. You can allow access to the Address Book or recipient information for up to ten minutes after you receive the dialog box. This allows features, such as mobile device synchronization, to be completed.
You receive the confirmation dialog box when a solution tries to programmatically access the following properties of the AppointmentItem object:
Organizer
RequiredAttendees
OptionalAttendees
Resources
NetMeetingOrganizerAlias
0
 
lrbristerAuthor Commented:
Number-1.
Thanks...I'll try and review this today or over the weekend.

May take me a a couple of days to get back
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
lrbristerAuthor Commented:
boag2000
Thanks. I'll review that as well
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Yes, there are many links to ways of doing this.
All using the same basic code

Here is a cool MS Link:
http://msdn.microsoft.com/en-us/library/office/aa159619%28v=office.11%29.aspx#odc_ac_olauto_addappointmentstooutlook

You can search here or in Google/Bing for many more.

Enjoy the weekend.

;-)

JeffCoachman
0
 
lrbristerAuthor Commented:
Thanks folks!
0
All Courses

From novice to tech pro — start learning today.