AW: Outlook Betreffzeile auslesen
25.07.2019 14:16:47
peterk
Hallo
z.B. Suchtext = "ISA", es werden alle Betreffs mit diesm Suchtext in das Blatt "Auswertung" geschrieben
Sub ReadOutlookMail()
Const olFolderInbox = 6
Dim olApp As Object
Dim MAPISpace As Object
Dim MailItem As Object
Dim suchString As String
Dim ze As Long
Set olApp = CreateObject("Outlook.Application")
Set MAPISpace = olApp.GetNamespace("MAPI")
Set olFolder = MAPISpace.GetDefaultFolder(olFolderInbox)
suchString = "ISA" ' anpassen
ze = 2
For Each MailItem In olFolder.Items
If InStr(1, MailItem.Subject, suchString, vbTextCompare) > 0 Then
Worksheets("Auswertung").Cells(ze, 1) = MailItem.Subject
ze = ze + 1
End If
Next MailItem
Set olApp = Nothing
Set MAPISpace = Nothing
Set olFolder = Nothing
End Sub