User Profile

Collapse

Profile Sidebar

Collapse
daruse712
daruse712
Last Activity: Aug 17 '07, 06:10 PM
Joined: Aug 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • daruse712
    started a topic Find() for calender items not working

    Find() for calender items not working

    Hi there,
    I'm using the find and findNext functions to retrieve appointments from the calendar but for some reason it either returns none at all or all items. This is the string I use:

    Code:
        strFind = "[Start] <= '" & Format(appt.start) & "'"
        Set foundAppt = calItems.Find(strFind)
    appt is a Outlook.Appoint mentItem variable that is recieved in the inbox.
    ...
    See more | Go to post

  • I got through the error by using the Typedef function:

    Code:
        Do Until TypeName(foundAppt) = "Nothing" Or Not (TypeName(appt.Subject) = TypeName(foundAppt.Subject))
            Set foundAppt = calItems.FindNext()
        Loop
    Seems to work but I need to get the find() and findnext function to return the right items
    See more | Go to post

    Leave a comment:


  • microsoft outlook macro- Runtime error 91 - Object variable not set

    Hi there,
    I'm writing a function to search through a calendar to find any conflicting meeting times for the appointment recently recieved. Heres the code:

    Private Function isConflict(appt As Outlook.Appoint mentItem) As Boolean
    Dim strFind As String
    Dim foundAppt As Outlook.Appoint mentItem

    'string for a conflicting appointment
    'calItem.start <= appt.start < calItem.end
    ...
    See more | Go to post
No activity results to display
Show More
Working...