Export to Outlook

  • Thread starter Thread starter Steevo
  • Start date Start date
S

Steevo

I have a calendar saved in an Excel document but would like to transfer it
to the calendar in Outlook XP 2003 since I have just bought Office XP 2003.
Is there any automated way to export the data or, even better to link the
worksheet to my calendar in Outlook? I would prefer to continue using my
Excel interface although cannot synchronise it with my phone.


Maay Thanks
 
I'm not particularly expert in Outlook but I was able to export Calendar
data from Excel to Outlook. The first step is to see the format that
Outlook expects. Create an Excel export file from Outlook to do that. Use
File, Import and Export, "Export to a File" to kick off the wizard that
creates an Excel file from your existing Calendar data.

So now that you know what Outlook expects it appears you have to get your
existing Excel calendar file into that same format (or at least use the same
column headings) as the export file. Note that the name "Calendar" has to
be assigned to the data range in the Excel workbook (use Ctrl-F3 to open the
Define Name dialog). Then you can File, Import and Export to import your
Excel calendar data into Outlook.
 
Back
Top