import from excel into Outlook calendar? //

[mac]

Asking this question for an acquaintance:

"I'm trying to import from excel into Outlook calendar. This is excel 97
and outlook 97. I have access to more recent versions.
I want each row of the excel spreadsheet to create an appointment.
Everything works fine up to a point. I select import a file. I use excel.
Then I have the option of "Map Custom Fields". This I need to use because my
spread sheet has only two columns. One for Subject, one for Description."
The next step should be to select OK. But OK is greyed out.

 

[Sue Mosher [MVP]]

Appointments must have start and end times. Your spreadsheet will need to provide that information to the import wizard.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm

 

[Brian Lorraine]

You have to map something to the subject, and then the OK
button will be activated