Calendar from Excel to Outlook, Reminder On/Off field doesn't work

[Dan Kowalski]

I've got excel 2000 and outlook 2003.
I had downloaded a schedule in an Excel file to import to my Outlook
calendar. I set up reminder times and imported it, the times seem to have
come in okay but the reminder wasn't set. So I changed the values in the
Reminderonoff column and imported again (overwrite) and they still weren't
set. "False" doesn't turn them on and "True" doesn't turn them on, what will?
I also exported the calendar because I had some appointments where the
reminder was on to see how it was done but there doesn't seem to be any
difference between the ones I know the reminder is on and the ones I know the
reminder is off.
There are 82 entries and I don’t want to turn them on manually, is there any
way to turn the reminders on in the Excel file?

 

[Diane Poremsky [MVP]]

Are you setting a reminder date and time?

See http://www.outlook-tips.net/archives/2008/20080529.htm for a way to
change it after importing.


--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[Dan Kowalski]

Yes, I filled the columns for reminder time and date. When I look at the
appointments they all have the times I set but the reminder is off. The times
for the reminders come through fine it is just that FALSE in the
Reminderonoff did not turn it on, so I changed that column to TRUE and
reimported with "Replace duplicates with items imported" checked and the
reminders are all still off.

Is there some other value that needs to be in this column, or is there no
way to turn the reminders on with a calendar imported from excel? The dates
and times for the reminders are coming in fine but the reminders are not "on."

Are you setting a reminder date and time?

See http://www.outlook-tips.net/archives/2008/20080529.htm for a way to
change it after importing.


--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

I've got excel 2000 and outlook 2003.
I had downloaded a schedule in an Excel file to import to my Outlook
calendar. I set up reminder times and imported it, the times seem to have
come in okay but the reminder wasn't set. So I changed the values in the
Reminderonoff column and imported again (overwrite) and they still weren't
set. "False" doesn't turn them on and "True" doesn't turn them on, what
will?
I also exported the calendar because I had some appointments where the
reminder was on to see how it was done but there doesn't seem to be any
difference between the ones I know the reminder is on and the ones I know
the
reminder is off.
There are 82 entries and I don’t want to turn them on manually, is there
any
way to turn the reminders on in the Excel file?

 

[Dan Kowalski]

:

See http://www.outlook-tips.net/archives/2008/20080529.htm for a way to
change it after importing.

That helped eliminate opening each indiviual appointment, but I still
couldn't figure how to turn them all on at once, I had to click each one. It
would have been nice if I could have shift selected them all and turned all
the reminders on at once.

I would still like to know how to do it from the excel file though.

 

[Dan Kowalski]

I was playing around with this and finally discovered what was wrong. I went
into "Map Custom Fields" and the "Reminder On/Off" was not properly mapped.
Now that it is correctly mapped it works fine. I wonder why it wasn't right?
(I'm trying to remember if it even worked before and if IT had monkeyed with
something since then.)