Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Calendaring / August 2007

Tip: Looking for answers? Try searching our database.

Importing from Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richie - 28 Aug 2007 14:42 GMT
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
Signature

Niall

Gordon - 28 Aug 2007 17:05 GMT
> Hello there,
>
[quoted text clipped - 12 lines]
>
> Any ideas or help - greatly appreciated.

Have you named the range in the Excel workbook?
Richie - 29 Aug 2007 11:38 GMT
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
Signature

Niall

> > Hello there,
> >
[quoted text clipped - 14 lines]
>
> Have you named the range in the Excel workbook?
Gordon - 29 Aug 2007 16:12 GMT
> 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....)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.