Dim
Empfänger
As
String
, Betreff
As
String
Dim
OutApp
As
Object
, Mail
As
Object
, i
Dim
ClpObj
As
DataObject
Dim
Nachricht
Empfänger = Range(
"B3"
).Value
Betreff =
"Angebot"
Set
ClpObj =
New
DataObject
Set
OutApp = CreateObject(
"Outlook.Application"
)
Set
Nachricht = OutApp.CreateItem(0)
With
Nachricht
.
To
= Empfänger
.Subject = Betreff
.Display
End
With
Set
OutApp =
Nothing
Set
Nachricht =
Nothing
End
Sub