1. You probably didn't create a named range for the entire range you are
importing.
2. Windows CSV will also work. The main reason for using Excel is because
it's easier to see the fields and you can use Excel tools to automate
creating the items.... but its just as easy to save a CSV from Excel.
--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks?
http://www.outlook-tips.net/beginner/
Outlook 2007:
http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
dailytips-subscribe-request@
lists.outlooktips.net
Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:
http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@
PEACH.EASE.LSOFT.COM
"Philip Stromme"
discussions.microsoft.com> wrote in message
news:41D09B28-797E-42DF-9CF5-293E6300FA79@microsoft.com...> It has been awhile since I figured this out, so my details might not be
> exact...
>
> I discovered the same problem that you are having. On a whim, I decided to
> save the file as a comma separated values (*.csv) file, rather than an
> *.xls
> file. When I did that, it imported everything correctly. You start the
> same
> way - Import from another file, then select Comma Separated Values. If I
> remember correctly, there are two options for importing csv files - DOS
> and
> Windows. I used the DOS selection, and it worked fine. I don't know if
> using
> the Windows selection would make a difference or not.
>
> Good luck,
> ~ Phil
>
> "Philip Stromme" wrote:
>
>> I was looking for this same information.
>> I tried using the technique in the webpage you gave, but it didn't work
>> right. It would only import one item from the excel spreadsheet, instead
>> of
>> all of the items.
>>
>> I see a certain a student once every 4 school days. Here is what I did:
>> 1) I made a spreadsheet listing each date that I will see that student:
>> Subject StartDate StartTime EndDate EndTime
>> Susie 9/4/2007 10:25:00 AM 9/4/2007 11:15:00 AM
>> Susie 9/10/2007 10:25:00 AM 9/10/2007 11:15:00 AM
>> Susie 9/14/2007 10:25:00 AM 9/14/2007 11:15:00 AM
>> Susie 9/20/2007 10:25:00 AM 9/20/2007 11:15:00 AM
>> Susie 9/26/2007 10:25:00 AM 9/26/2007 11:15:00 AM
>> 2) I imported the spreadsheet into Outlook.
>> 3) When I verified that the data was imported correctly, only one
>> instance
>> was imported.
>>
>> Can you help me figure out what's going wrong?
>>
>> Thanks,
>> ~ Phil
>>
>>
>> "Diane Poremsky" wrote:
>>
>>>> My son just started school today and there school runs on a 6 day
>>>> cycle.
>>>> For
>>>> example day 1 is gym, day 2 is art and so on. Is there a way to set
>>>> this
>>>> up
>>>> as a reminder in outlook calender for the 6 days without doing each
>>>> one
>>>> seperate for the 180 school days
>>>> thanks
>>>> sam
>>>>
