• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Importing directly into Calendar????

Is it possible to import data from Access database directly into an Outlook 2000 Calendar using VBA???  I can import into a newly created Calendar, but do not appear to be able to import into the Default Calendar.  If it is possible how do I reference it?  Here is the code I use to create a new Calendar:

strFolder = "Calendar from Access"
Set fld = nms.Folders("Mailbox - User1").Folders.add(strFolder, olFolderCalendar)

Can anyone help me modify this so that it imports into the standard Calendar?
0
mercia
Asked:
mercia
1 Solution
 
rjcpjcCommented:
mercia (I hope you don't think I forgot about you).  Its been busy at my office.  

Anyway, here is the code to reference the default calendar and I'm going back to your other question about the find folder sub in just a minute.  

Set fld = nms.GetDefaultFolder(olFolderCalendar)


This is assuming that you have a valid namespace object (nms).  If this doesn't work for you let me know.  The other way to do it is to use the nms.GetSharedDefaultFolder method if you want to get another user's calendar (other than the profile you are using to log into Outlook on the machine the VBA code is running on).  

Now back to your other question with apologies that it took so long.  

--Patricia
0
 
merciaAuthor Commented:
Thanks I nearly had it I was trying DefaultFolder(olCalendar) hence why it did not work.  Now I can move on to my next problem!  Cheers

Wayne
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now