Importing Appointment Labels

G

Guest

I have a .csv file that i'm going to be updating and importing daily into a
shared calendar, however I don't see a field to map the appointment label.
Does anyone know of another way for Outlook to read the csv file and assign
the different labels to the appointments?
 
R

Roady [MVP]

Version of Outlook?
Which labels are you referring at?
How did you create the csv-file?
Why not use iCal instead?
 
G

Guest

I'm using 2003.
I'm reffering to the labels that you can assign to the appointments that
will change the color that appears on the calendar.
The csv file is created from an Excel export from a software package that my
company makes. I run a macro on it to put in the appropriate headers for
mapping the import and then save it as a csv file.
I've never use iCal. What's that?

Roady said:
Version of Outlook?
Which labels are you referring at?
How did you create the csv-file?
Why not use iCal instead?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

Dave L said:
I have a .csv file that i'm going to be updating and importing daily into a
shared calendar, however I don't see a field to map the appointment label.
Does anyone know of another way for Outlook to read the csv file and
assign
the different labels to the appointments?
 
R

Roady [MVP]

iCal is a standardized method to support Calendar items;
http://www.ietf.org/rfc/rfc2445.txt

ics and vcs are the supported file formats for that but I believe that
previous version of Outlook (before 2007) don't support vcs

Note that category labels are local to the user but you can use the status
lables.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

Dave L said:
I'm using 2003.
I'm reffering to the labels that you can assign to the appointments that
will change the color that appears on the calendar.
The csv file is created from an Excel export from a software package that
my
company makes. I run a macro on it to put in the appropriate headers for
mapping the import and then save it as a csv file.
I've never use iCal. What's that?

Roady said:
Version of Outlook?
Which labels are you referring at?
How did you create the csv-file?
Why not use iCal instead?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

Dave L said:
I have a .csv file that i'm going to be updating and importing daily
into a
shared calendar, however I don't see a field to map the appointment
label.
Does anyone know of another way for Outlook to read the csv file and
assign
the different labels to the appointments?
 
G

Guest

I'm not familiar with status labels. What are those? Forgive me if I'm asking
dumb questions but I typically only use Outlook for emails and appointments.

Roady said:
iCal is a standardized method to support Calendar items;
http://www.ietf.org/rfc/rfc2445.txt

ics and vcs are the supported file formats for that but I believe that
previous version of Outlook (before 2007) don't support vcs

Note that category labels are local to the user but you can use the status
lables.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

Dave L said:
I'm using 2003.
I'm reffering to the labels that you can assign to the appointments that
will change the color that appears on the calendar.
The csv file is created from an Excel export from a software package that
my
company makes. I run a macro on it to put in the appropriate headers for
mapping the import and then save it as a csv file.
I've never use iCal. What's that?

Roady said:
Version of Outlook?
Which labels are you referring at?
How did you create the csv-file?
Why not use iCal instead?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

-----

I have a .csv file that i'm going to be updating and importing daily
into a
shared calendar, however I don't see a field to map the appointment
label.
Does anyone know of another way for Outlook to read the csv file and
assign
the different labels to the appointments?
 
R

Roady [MVP]

Status;
-Busy
-Free
-Tentative
-Out of Office

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

Dave L said:
I'm not familiar with status labels. What are those? Forgive me if I'm
asking
dumb questions but I typically only use Outlook for emails and
appointments.

Roady said:
iCal is a standardized method to support Calendar items;
http://www.ietf.org/rfc/rfc2445.txt

ics and vcs are the supported file formats for that but I believe that
previous version of Outlook (before 2007) don't support vcs

Note that category labels are local to the user but you can use the
status
lables.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

Dave L said:
I'm using 2003.
I'm reffering to the labels that you can assign to the appointments
that
will change the color that appears on the calendar.
The csv file is created from an Excel export from a software package
that
my
company makes. I run a macro on it to put in the appropriate headers
for
mapping the import and then save it as a csv file.
I've never use iCal. What's that?

:

Version of Outlook?
Which labels are you referring at?
How did you create the csv-file?
Why not use iCal instead?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

-----

I have a .csv file that i'm going to be updating and importing daily
into a
shared calendar, however I don't see a field to map the appointment
label.
Does anyone know of another way for Outlook to read the csv file and
assign
the different labels to the appointments?
 

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

Top