John Colby
jwcolby at ColbyConsulting.com
Sun Jan 8 10:24:14 CST 2006
The following code was working in an Access project for sensing messages in a folder and processing the email. I am trying to build a little application for preparing my spam to be sent off to BlueFrog for reporting. The code is not working from directly inside of Outlook. The code gets here, but the Items collection never contains anything, even when there is email in the folder. Any ideas? Function CheckForSpamMail(fldrSpamIncoming As Outlook.MAPIFolder) As Boolean On Error GoTo Err_CheckForSpamMail Dim msg As Outlook.MailItem Debug.Print fldrSpamIncoming.Name For Each msg In fldrSpamIncoming.Items Debug.Print "CheckForSpamMail - Processing message #" & intMsgCnt; " of " & fldrSpamIncoming.Items.Count ProcessSpamMail fldrSpamIncoming, msg Next msg ' intMsgCntOrig = fldrSpamIncoming.Items.Count ' For intMsgCnt = 1 To intMsgCntOrig ' Set msg = fldrSpamIncoming.Items(1) ' Debug.Print "CheckForSpamMail - Processing message #" & intMsgCnt; " of " & fldrSpamIncoming.Items.Count ' ProcessSpamMail fldrSpamIncoming, msg ' Next intMsgCnt Exit_CheckForSpamMail: On Error Resume Next Set msg = Nothing Exit Function Err_CheckForSpamMail: Select Case Err Case 0 '.insert Errors you wish to ignore here Resume Next Case -2147352567 'No messages Resume Exit_CheckForSpamMail Case Else '.All other errors will trap Beep MsgBox Err.Number & ":" & Err.Description, , "Error in Function dclsOutlook.CheckForSpamMail" Resume Exit_CheckForSpamMail End Select Resume 0 '.FOR TROUBLESHOOTING End Function John W. Colby www.ColbyConsulting.com