Sub
SaveMailAsFile()
Const
OLTXT = 0
Dim
oMail
As
Outlook.MailItem
Dim
sPath
As
String
Dim
dtDate
As
Date
Dim
sName
As
String
Set
oMail = Application.ActiveExplorer.Selection.Item(1)
sName = oMail.Subject
ReplaceCharsForFileName sName,
"_"
dtDate = oMail.ReceivedTime
sName = Format(dtDate,
"yyyymmdd"
, vbUseSystemDayOfWeek, _
vbUseSystem) & Format(dtDate,
"-hhnnss"
, _
vbUseSystemDayOfWeek, vbUseSystem) &
"-"
& sName &
".txt"
oMail.SaveAs "C:\EDP2\Einsatzserver\test\" & sName, OLTXT
End
Sub
Private
Sub
ReplaceCharsForFileName(sName
As
String
, _
sChr
As
String
_
)
sName = Replace(sName,
"/"
, sChr)
sName = Replace(sName, "\", sChr)
sName = Replace(sName,
":"
, sChr)
sName = Replace(sName,
"?"
, sChr)
sName = Replace(sName, Chr(34), sChr)
sName = Replace(sName,
"<"
, sChr)
sName = Replace(sName,
">"
, sChr)
sName = Replace(sName,
"|"
, sChr)
End
Sub