Chilkat HOME Android™ Classic ASP C C++ C# Mono C# .NET Core C# C# UWP/WinRT DataFlex Delphi ActiveX Delphi DLL Visual FoxPro Java Lianja MFC Objective-C Perl PHP ActiveX PHP Extension PowerBuilder PowerShell PureBasic CkPython Chilkat2-Python Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ Visual Basic 6.0 VB.NET VB.NET UWP/WinRT VBScript Xojo Plugin Node.js Excel Go
(Excel) Scan for Emails with Attachments and Save Attachments to FilesScan for emails with attachments and save attachments.
' This example requires the Chilkat API to have been previously unlocked. ' See Global Unlock Sample for sample code. Dim imap As Chilkat.Imap Set imap = Chilkat.NewImap ' Connect to an IMAP server. ' Use TLS imap.Ssl = True imap.Port = 993 success = imap.Connect("imap.someMailServer.com") If (success <> True) Then Debug.Print imap.LastErrorText Exit Sub End If ' Login success = imap.Login("myLogin","myPassword") If (success <> True) Then Debug.Print imap.LastErrorText Exit Sub End If ' Select an IMAP mailbox success = imap.SelectMailbox("Inbox") If (success <> True) Then Debug.Print imap.LastErrorText Exit Sub End If ' We can choose to fetch UIDs or sequence numbers. fetchUids = True ' Get the message IDs of all the emails in the mailbox Set messageSet = imap.Search("ALL",fetchUids) If (imap.LastMethodSuccess <> True) Then Debug.Print imap.LastErrorText Exit Sub End If ' Fetch the email headers into a bundle object: Set bundle = imap.FetchHeaders(messageSet) If (imap.LastMethodSuccess <> True) Then Debug.Print imap.LastErrorText Exit Sub End If ' Scan for emails with attachments, and save the attachments ' to a sub-directory. For i = 0 To bundle.MessageCount - 1 Set email = bundle.GetEmail(i) ' Does this email have attachments? ' Use GetMailNumAttach because the attachments ' are not actually in the email object because ' we only downloaded headers. ' (Had we downloaded the full emails by ' calling mailman.FetchBundle, we could look ' at the email object's NumAttachments property.) numAttach = imap.GetMailNumAttach(email) If (numAttach > 0) Then ' Download the entire email and save the ' attachments. (Remember, we ' need to download the entire email because ' only the headers were previously downloaded. ' If the entire emails were downloaded by ' calling FetchBundle instead of FetchHeaders, ' this would not be necessary. ' The ckx-imap-uid header field is added when ' headers are downloaded. This makes it possible ' to get the UID from the email object. uidStr = email.GetHeaderField("ckx-imap-uid") uid = CLng(uidStr) Set fullEmail = imap.FetchSingle(uid,True) If (imap.LastMethodSuccess = True) Then success = fullEmail.SaveAllAttachments("attachmentsDir") End If For j = 0 To numAttach - 1 filename = imap.GetMailAttachFilename(email,j) Debug.Print filename Next End If Next ' Disconnect from the IMAP server. success = imap.Disconnect() |
© 2000-2022 Chilkat Software, Inc. All Rights Reserved.