Importing from Excel

[Guest]

Hello there,

I have exported appointments from Calendar to excel but I now wish to Import
appointments from Excel back into Outlook. Everything works fine except that
when it is completed the data is not there ? Whats gone wrong I ask. I
notice that when you expoert from calendar to excel it is exporting from
"Appointments" from folder: "Calendar" but when importing from excel to
calendar it says Import from "Calendar" into folder: Calendar

I am using Outlook 2002 by the way and I was importing the same file
exported with only the additions of appointments and it only added the one
that was originally exported.

Any ideas or help - greatly appreciated.

Richie

 

[Gordon]

Hello there,

I have exported appointments from Calendar to excel but I now wish to
Import
appointments from Excel back into Outlook. Everything works fine except
that
when it is completed the data is not there ? Whats gone wrong I ask. I
notice that when you expoert from calendar to excel it is exporting from
"Appointments" from folder: "Calendar" but when importing from excel to
calendar it says Import from "Calendar" into folder: Calendar

I am using Outlook 2002 by the way and I was importing the same file
exported with only the additions of appointments and it only added the one
that was originally exported.

Any ideas or help - greatly appreciated.

Have you named the range in the Excel workbook?

 

[Guest]

Gordon, thanks for the reply.

I have not named the range in the workbook as I just exported to the
workbook add a few rows of information and import it back.

Does Outlook create a range name automatically and call it appointments ?

Regards

 

[Gordon]

Gordon, thanks for the reply.

I have not named the range in the workbook as I just exported to the
workbook add a few rows of information and import it back.

Does Outlook create a range name automatically and call it appointments ?

No - to be able to import from an Excel workbook you need to name the range
that you are wanting to import. (AFAIK it doesn't matter what you call
it....)