View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve_doc steve_doc is offline
external usenet poster
 
Posts: 140
Default Create Outlook event/appt in non-default calendar folder

Hi

The following code from www.excelkb.com gives some clues
This is not for the calender but for the journal items

Dim olApp As Outlook.Application

Dim olNamespace As Outlook.Namespace

Dim olJourFolder As Outlook.MAPIFolder

Dim olJourItem As Outlook.JournalItem

From the above after setting reference to the Outlook object model
You should have access to all objects within the Object browser - search for
calender

HTH

"Barb Reinhardt" wrote:

Have you tried asking in the Outlook newsgroup for assistance in doing this
in outlook. Once that's together, we probably can help get it to run out of
Excel.

"Finny388" wrote:

Boy this kind of info is scarce.

I just want a routine that will create events in Outlook based on cell
contents.

I can't find how to reference a specific/non-default calendar folder,
let alone do this at all.

Help?

Thanks