A1: E-Mail erhalten am
B1: Produkt-Nummer
C1: Link zum Produkt
D1: Datum mit Uhrzeit
Hallo XY,
blabla Produkt_01 läuft aus am 01.01.2024 12:00
VG
Option Explicit
Sub ExtractData()
Dim O As Outlook.Application
Set O = New Outlook.Application
Dim OMAIL As Outlook.MailItem
Set OMAIL = O.CreateItem(olMailItem)
Dim ONS As Outlook.Namespace
Set ONS = O.GetNamespace("MAPI")
Dim MYFOL As Outlook.Folder
Set MYFOL = ONS.GetDefaultFolder(olFolderInbox).Folders("Test")
' für Posteingang: Set MYFAL = ONS.GetDefaultFolder(olFolderInbox)
Dim MYARRAY As Variant
For Each OMAIL In MYFOL.Items
MYARRAY = Split(OMAIL.Body, vbCrLf)
Next OMAIL
End Sub
Sub Kisska()
Dim EML As MailItem, Tag As Date, RegEx As Object, RR As Object
Dim Doc As Word.Document
If RegEx Is Nothing Then Set RegEx = CreateObject("VBScript.RegExp")
RegEx.Pattern = "\d{2}\.\d{2}\.\d{4}\s\d{2}:\d{2}"
Set EML = ActiveExplorer.Selection(1)
Set RR = RegEx.Execute(EML.Body)
Set Doc = EML.GetInspector.WordEditor
Debug.Print EML.ReceivedTime, CDate(RR(0)), Doc.Hyperlinks(1).Address
End Sub
Option Explicit
Sub BodyAusGeloeschtenEmailsLesen()
Dim O As Outlook.Application
Dim OMAIL As Outlook.MailItem
Dim ONS As Outlook.Namespace
Dim MYFOL As Outlook.Folder
Dim MYARRAY As Variant
Set O = New Outlook.Application
Set OMAIL = O.CreateItem(olMailItem)
Set ONS = O.GetNamespace("MAPI")
Set MYFOL = ONS.GetDefaultFolder(olFolderDeletedItems)
For Each OMAIL In MYFOL.Items
MYARRAY = Split(OMAIL.Body, vbCrLf)
Next OMAIL
End Sub
Option Explicit
Sub BodyAusGeloeschtenEmailsLesen()
Dim O As Outlook.Application
Dim OMAIL As Outlook.MailItem
Dim ONS As Outlook.Namespace
Dim MYFOL As Outlook.Folder
Dim MYARRAY As Variant
Dim arr(), i&, iZeilen&, iItems&
Set O = New Outlook.Application
Set OMAIL = O.CreateItem(olMailItem)
Set ONS = O.GetNamespace("MAPI")
Set MYFOL = ONS.GetDefaultFolder(olFolderDeletedItems)
For Each OMAIL In MYFOL.Items ' Schleife zum lesen der maximalen Dimensionierung des Arrays
MYARRAY = Split(OMAIL.Body, vbCrLf)
iItems = iItems + 1
If UBound(MYARRAY) > iZeilen Then iZeilen = UBound(MYARRAY)
Next OMAIL
ReDim arr(1 To iItems + 1, 1 To iZeilen) ' Dimensionierung des Arrays
iItems = 0
For Each OMAIL In MYFOL.Items ' Schleife zum füllen des Arrays
MYARRAY = Split(OMAIL.Body, vbCrLf)
iItems = iItems + 1
For i = 1 To UBound(MYARRAY)
arr(iItems, i) = MYARRAY(i - 1)
Next i
Next OMAIL
Tabelle1.Cells(1, 1).Resize(UBound(arr, 1), UBound(arr, 2)) = arr
End Sub
Set MYFOL = ONS.GetDefaultFolder(olFolderDeletedItems)
Set MYFOL = ONS.GetDefaultFolder(olFolderTest)
Set MYFOL = ONS.GetDefaultFolder(olFolderInbox).Folders("Test") ' für Posteingangsordner
MYFOL.Folders.Add ("TestIrgenwas")
MYFOL.Folders("TestIrgenwas").Delete
Set MYFOL = ONS.Folders.Item("Persönliche Ordner").Folders("Test")
Option Explicit
Sub BodyAusGeloeschtenEmailsLesen()
Dim O As Outlook.Application
Dim OMAIL As Outlook.MailItem
Dim ONS As Outlook.Namespace
Dim MYFOL As Outlook.Folder
Dim MYARRAY As Variant
Dim arr(), i&, iZeilen&, iItems&
Set O = New Outlook.Application
Set OMAIL = O.CreateItem(olMailItem)
Set ONS = O.GetNamespace("MAPI")
Set MYFOL = ONS.GetDefaultFolder(olFolderDeletedItems)
For Each OMAIL In MYFOL.Items ' Schleife zum lesen der maximalen Dimensionierung des Arrays
MYARRAY = Split(OMAIL.Body, vbCrLf)
iItems = iItems + 1
If UBound(MYARRAY) > iZeilen Then iZeilen = UBound(MYARRAY)
Next OMAIL
ReDim arr(1 To iItems + 1, 1 To iZeilen) ' Dimensionierung des Arrays
iItems = 0
For Each OMAIL In MYFOL.Items ' Schleife zum füllen des Arrays
MYARRAY = Split(OMAIL.Body, vbCrLf)
iItems = iItems + 1
For i = 1 To UBound(MYARRAY)
arr(iItems, i) = MYARRAY(i - 1)
Next i
Next OMAIL
Tabelle1.Cells(1, 1).Resize(UBound(arr, 1), UBound(arr, 2)) = arr
End Sub
Set MYFOL = ONS.GetDefaultFolder(olFolderInbox).Folders("Test") ' für Posteingangsordner