Importing from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Richie said:
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.
Click to expand...

Have you named the range in the Excel workbook?
 
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
 
Richie said:
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 ?
Click to expand...

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....)
 
Back
Top