Importing appointments

[Lee]

New at this so pardon my

Using MS Office 2003 Pro.

Exported my current calendar data to obtain Outlook calendar
appointment header row titles: Subject, StartDate, StartTime, EndDate,
EndTime, Alldayevent, Reminderonoff, ReminderDate, ReminderTime, and
Private (the other fields contained no data - did not try to import
empty fields).

Loaded my new data into either Excel spreadsheet with identical
headers, CVS file with identical headers, delimited text file with
identical headers, or Access mdb table with identical headers.

Using these headers in Excel xls file, Excel cvs, Text txt delimited,
and Access mdb file types, I cannot get the imported Calender data to
correctly/consistently have the Reminder checkbox "checked".

I have tried TRUE, FALSE, ON, OFF, 0, AND -1 as the values in the
Reminderonoff field but nothing seems to work. (importing existing
calendared appointments into Access has values as either 0 or -1, while
Excel used TRUE or FALSE).

I am not using custom fields, only basic Outlook calendar field names.

Any help greatly appreciated.

 

[Guest]

Hi,

I am using Outlook Express 6 2004

Where is my clander and how do i use it

thanks
In rules how do i make it go straingth into my folder and not keep one in my
inbox???

 

[Brian Tillman]

I am using Outlook Express 6 2004

There is no such application. Outlook Express V6 does exist, but I don't
know where you got "2004".

Where is my clander and how do i use it

Outlook Express doesn't have a calendar function. Microsoft Outlook,
however, which is part of the Office suite, does have calendaring functions.
Despite the similar names, the two are unrelated.

In rules how do i make it go straingth into my folder and not keep
one in my inbox???

Make sure you include the "stop processing more rules" action and use "move"
instead of a "copy" action.

 

[Lee]

Appear to have a least a work around problem. Input needed data into
Excel spreadsheet with first row containing header titles matching
sample export of single appointment from Outlook calendar. Took
spreadsheet and imported into new (blank) MS Access database, Exported
this table into new Excel spreadsheet. Opened Outlook calendar and
mapped "remindersonoff" field when requested to map fields - all others
matched. Imported perfectly with reminders checked off as expected.