Format required for Excel import into Outlook 2002 Calendar?

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

Guest

I would like to efficiently import project summary project information into
Outlook Calendar. Correct me if I'm wrong but I think the easiest way is to
export from Project to Excel and then import into Outlook. Ive tried this
but I haven't had any success. I get an error message complaining that I
haven't created any named ranges in Excel. Seems to me it should ask me to
do some mapping too or there should be a specific format that is required.
I've searched the documentation and the web site but can find nothing that
provides this.
 
You have to solve the named range problem first. Select all the data you want to import, then choose Insert | Name | Define and give the range a name. Save the .xls file and import in Outlook.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
Which is the best MBOX Converter Tool different formats conversion? 4
Imports from Excel 1
Import Excel Meeting Requests to Outlook 2
HOW TO IMPORT EXCEL FILE INTO OUTLOOK 2003 CALENDAR 1
Importing from Excel 3
importing windows vista calendar to outlook calendar 7
Importing Excel Calendar Items into Outlook 2

Back
Top