Importing data into Outlook calendar

[Doug Shank]

I'm trying to import Calendar Creator Plus data into Outlook. I found an
article in MSDN on how to do it (basically export from CC+ to a .csv file
and do an import into Outlook). This works fine, but my problem is this: I
can only import it into my own Calendar. I see no way of importing it into
someone else's calendar, which is what I would really like to do so I don't
have to get on the user's machine to do it.

Does anyone know of a way to do this? I was playing around trying to do a
vb app to do it remotely, but am having some troubles. I am
semi-experienced in Outlook automation, and can get the recipient's
calendar, etc. via MAPI/CDO or Outlook, but can't figure out how to do the
import. Despite all my efforts, this (maybe simple?) task eludes me. I've
checked several different objects/angles via the object browser and help
files...Folder object, Session object, etc. but haven't found any methods,
etc. to point me in the right direction.

Any help in how to a) do this through code (preferable), or b) do it through
the Outlook interface (acceptable) will be greatly appreciated!

Thanks in advance for any help.

Doug

[Mark Anderson]

Here's the way I've had luck in a similiar task. I created a Personal Folder
file where I created a calendar (under the personal folder right click and
choose add folder, select "contains appointment items") to be the source of
the imported data that you could then forward to the other person to import.
After you've exported the CC+ info (as detailed below), you can select the
calendar under your Personal Folder as the destination. I then e-mailed the
pst file to the other person where they can add this personal folder, select
all and copy into their desired calendar. The pst file was less than a MB,
so you could also probably put it on a disk and give it to the person if
needed. The next steps are probably the ones you had success with, but I'll
write them down in case someone else may need them.

Save the Calendar Creator Plus File as a CSV File: First open the calendar
that you have created. On the File menu, point to Save As, and click to
select the Event list you want to export.

In the Save Event List, type a file name.

In the Save File As Type list, click to select Comma Delimited (.csv). Do
not select the DOS option. Make a note of the folder where the file will be
saved, and click OK.

In the "Specify date range" dialog, type the Starting and Ending dates you
want to export and click OK.

On the File menu, click Exit.

At this point it is necessary to assure that the fields exported from
Calendar Creator Plus contain fields that exactly match with the internal
fields used by the Outlook Calendar. If these fields do not match, no data
will be imported. The fields in the exported file should be manually edited
through Excel to match the following:

CALENDAR CREATOR PLUS FIELD OUTLOOK FIELD
Field 1 Start Date
Field 2 Start Time
Field 3 End Time
Field 4 Subject
Field 5 Priority
Field 6 Category
Field 7 <none, contains Picture files>
Field 8 <none, note information>

To add these fields you will have to Add a row in Excel and enter the text
there. You must then save what you have changed and then close excel. When
you close excel you will be asked if you want to convert the file to an excel
format because it is currently not in a excel format. Your answer to this
should be NO.
There is no Note field in Outlook; you may use it for another field, such as
Location.
Import the CSV File into Outlook:

On the File menu, click Import and Export.

Click to select "Import from another program or file," and click Next.

Click to select "Comma Separated Values (Windows)," and click Next.

Click Browse and locate the folder where you saved the CSV file. (Step 3 in
the "Save the Calendar Creator Plus File as a CSV File" section.) Click to
select the file, click Open, and then click Next. Click to select your
Calendar as the import location.

Click OK, and click Finish.

The Outlook Calendar displays the imported data.

Hope this helps...

In article <7gv3q5$2ef$1...@autumn.news.rcn.net>,

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[Chris Burnham]

You won't be able to access another users folder unless you are an
Exchange Administrator with proper authorizations, or the user has set
you up with proper authorizations.

--
Regards,
Chris Burnham
Grand Rapids, MI

Please reply to the newsgroups so that others can benefit from the
discussion. Also note that I do not send replies to newsgroup postings
by e-mail I volunteer my time in the groups. Thanks for understanding
and supporting the forum.

Answers to many of the questions commonly asked here can be found in
Microsoft's Outlook FAQ:
http://support.microsoft.com/support/outlook/faq/ol98/
____________________________________________________
Doug Shank <drs...@hotmail.com> wrote in message
news:7gv3q5$2ef$1...@autumn.news.rcn.net...

[Doug Shank]

This sounds great, but I have one (simple?) question. Once the user opens
the pst, how can they select all appointments and move them to their
calendar folder. Maybe it's my inexperience with the Outlook GUI, but the
only way I can find to move an item is to right click and select 'move to
folder' (or drag the appointment(s) to the destination folder), in which
case it only moves the selected item(s). I see you can do shift-click to
select multiple and move all selected items to a folder, but I can find no
option to 'select all' or anything similar. There are going to be a slew of
appointments I am dealing with, covering a year or more, and having the user
hold down shift while selecting each appointment, then doing the 'move to
folder' option is going to be too difficult and tedious for the user base I
am aiming this at. If it's not a quick, two or three click scenario, they
won't bite.

Thanks again for any help.

Doug

Mark Anderson wrote in message <7gvk4p$vc0$1...@nnrp1.deja.com>...

[Doug Shank]

Even with full rights to another user's calendar folder, I am still unable
to do an Import/Export...the option is not present in the File menu. Am I
missing something? Are there rights aside from Calendar folder that I need
to have? Or is this by design?

Thanks
Doug

Chris Burnham wrote in message <#Kk6KNOm#GA...@cppssbbsa02.microsoft.com>...

>You won't be able to access another users folder unless you are an
>Exchange Administrator with proper authorizations, or the user has set
>you up with proper authorizations.
>
>--
>Regards,
> Chris Burnham
> Grand Rapids, MI
>
>Please reply to the newsgroups so that others can benefit from the
>discussion. Also note that I do not send replies to newsgroup postings
>by e-mail I volunteer my time in the groups. Thanks for understanding
>and supporting the forum.
>
>Answers to many of the questions commonly asked here can be found in
>Microsoft's Outlook FAQ:
>http://support.microsoft.com/support/outlook/faq/ol98/
>____________________________________________________
>Doug Shank <drs...@hotmail.com> wrote in message
>news:7gv3q5$2ef$1...@autumn.news.rcn.net...