Adding Appointments to Outlook from an Excel Workbook

[Lee_of_Excel]

Hi again all,

I am trying to use VBA to add Outlook appointments in Bulk from Excel.

I have written some code, but can't seem to understand where I am going wrong.

Please Login or Register  to view this content.

I am receiving an error "Compile Error" on oOL As Outlook.Application

I have searched the net but can't find a simple fix, basically I just want to capture:

Column A: Appointment Name
Column B: Date
Column C: Start Time
Column D: End Time
Column E: Appointment details (Body)


Any help would be great, happy to discard my code if you have a better way to do this,

Cheers

[BMV]

For your code you must :
Display the Tols/References dialog box.
Select the Microsoft Outlook x.xx object library

or
Dim oOL As object, oAppoint As object
but any outlook constants must be replaced to value or defined
Constant olAppointmentItem =1
Constant olNONMeeting = 0

[Lee_of_Excel]

Thanks BMV, I completely forgot about that.

I think that my coding needs some work still, it still seems to fail on r = oWS.Range("A1").CurrentRegion.Row.Count as invalid qualifier.

I'll see what I can do, cheers