Importing calendar entries into Access

  • Thread starter Thread starter Jaime
  • Start date Start date
J

Jaime

I posted this to an Access group yesterday. After more
research, I believe I may have been missing the point of
the referenced article, but I still can't find a way to
read calendar entries. I want to import them into an
Access table. I am using Office 2000.

Any help greatly appreciated.

Jaime

I found a very nice article,
http://support.microsoft.com/default.aspx?scid=kb;en-
us;209946&Product=acc2000, which had one ambiguity that I
have not been able to get past. It refers to a Message
Class field, but does not explain how this property is
assigned or even to what object. I assume it is a
property of the object returned by db.CreateTableDef(),
but I'm guessing.

I have two questions, "How do I apply this property?"
and "Where are these these methods documented?"

Any help would be appreciated.

The article said:

If items in the linked Microsoft Outlook folder use a
special form, you must enter the correct form type in the
Message Class field when you add new records to the
table. If you do not specify a Message Class, Microsoft
Outlook uses the default mail form to display your data.
The Message Classes for the standard Microsoft Outlook
folders are:

Folder Message Class
Calendar IPM.Appointment
Contacts IPM.Contact
Inbox IPM.Note
Journal IPM.Activity
Notes IPM.StickyNote
Tasks IPM.Task
 
There are several issues with what you are asking about. Outlook is a
mail client that stores its messages in Outlook folders (CDO or MAPI).
You can access Outlook folders using a Microsoft database connection API
called DAO as if they were database tables and export the information.
One property of an Outlook Item is the "type". If you look at the
example below you will see a line that reads:

If TypeName(objItems(i)) = "ContactItem" Then


You would want to modify that toe read somthing like:

If TypeName(objItems(i)) = "AppointmentItem" or TypeName(objItems(i)) =
"TashItem" Then

A more appropriate example for what you want, though it is for contacts,
is located here:

http://support.microsoft.com/?kbid=290792

You would also need to modify the MS Access table to address the Outlook
"fields" in the Appointments and Tasks. A good example showing these
field from an appointment can be found here:

http://www.topxml.com/snippetcentral/main.asp?view=viewsnippet&lang=xml&id=v20020414223234






---------------------------------
Trevor Lowing
Satellite Beach, Fl

(e-mail address removed)
---------------------------------
Need help with:
Access?
http://www.mvps.org/access/
Outlook?
http://www.slipstick.com/
Visio?
http://www.mvps.org/visio/
HTML/CSS?
http://www.NCDesign.org
Scripting(VBScript/JScript/WSH/XML)?
http://www.DevGuru.com
http://cwashington.netreach.net/
http://developer.irt.org/script/script.htm
---------------------------------
I posted this to an Access group yesterday. After more
research, I believe I may have been missing the point of
the referenced article, but I still can't find a way to
read calendar entries. I want to import them into an
Access table. I am using Office 2000.

Any help greatly appreciated.

Jaime

I found a very nice article,
http://support.microsoft.com/default.aspx?scid=kb;en-
us;209946&Product=acc2000, which had one ambiguity that I
have not been able to get past. It refers to a Message
Class field, but does not explain how this property is
assigned or even to what object. I assume it is a
property of the object returned by db.CreateTableDef(),
but I'm guessing.

I have two questions, "How do I apply this property?"
and "Where are these these methods documented?"

Any help would be appreciated.

The article said:

If items in the linked Microsoft Outlook folder use a
special form, you must enter the correct form type in the
Message Class field when you add new records to the
table. If you do not specify a Message Class, Microsoft
Outlook uses the default mail form to display your data.
The Message Classes for the standard Microsoft Outlook
folders are:

Folder Message Class
Calendar IPM.Appointment
Contacts IPM.Contact
Inbox IPM.Note
Journal IPM.Activity
Notes IPM.StickyNote
Tasks IPM.Task
Click to expand...







--
 
You may find this very helpful also.

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&[email protected]&rnum=4

--
---------------------------------
Trevor Lowing
Satellite Beach, Fl

(e-mail address removed)
---------------------------------
Need help with:
Access?
http://www.mvps.org/access/
Outlook?
http://www.slipstick.com/
Visio?
http://www.mvps.org/visio/
HTML/CSS?
http://www.NCDesign.org
Scripting(VBScript/JScript/WSH/XML)?
http://www.DevGuru.com
http://cwashington.netreach.net/
http://developer.irt.org/script/script.htm
---------------------------------
 
Back
Top