Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBScripting Outlook Calendar Items...Properties? 1

Status
Not open for further replies.

shinedog

MIS
Feb 24, 2004
60
US
Hey all, I am using the excerpt of code pasted below to get a list of recurring appointments out of the Outlook Calendar. The script I use it in actually works very well but... is there a list somewhere for the properties I can pull off a calendar item? Like for example, in the code below, it references FilteredAppointment.BusyStatus, .Sensitivity, .Start, .Duration, .Subject, etc. Is there a list somewhere of what properties of these calendar items I can retrieve? I'm specifically trying to see if I can get a list of attendees that are scheduled for the meeting or at least who it was sent to. I'm not sure that is possible though. But I would still like to see a list of the properties anyway. I Googled the hell out of it and can't seem to find it.

For Each FilteredAppointment in colFilteredItems
If FilteredAppointment.BusyStatus = 2 and FilteredAppointment.Sensitivity = 0 then
'If FilteredAppointment.Start >= dtLastWeek And FilteredAppointment.Start <= Date + 1 Then
icount = icount + 1
strOutput = strOutput & icount & ". " & FilteredAppointment.Subject & vbTab & _
" <b>Time:</b> " & FilteredAppointment.Start & _
" <b>Duration</b> " & FilteredAppointment.Duration & vbCRLF
txtNames = txtNames & FilteredAppointment.Subject & vbTab & _
" <b>Time:</b> " & FilteredAppointment.Start & _
" <b>duration</b> " & FilteredAppointment.Duration & vbCRLF
'End If
End If
Next
 
In the Outlook VBE (Alt-F11) use the F2 key (Object Browser)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
This is exactly what I was looking for. Funny how I was so apt to run to Google first and it was right under my nose all along! Thanks man!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top