AW: Outlook - Sicherheitsabfrage
14.10.2010 21:23:03
Frank
Hallo Rene,
die Variante mit WS Shell kenne ich gar nicht. Ich habe diesen Code im Forum gefunden:
Sub Test()
Dim oOL As Object
Dim oOLMsg As Object
Dim oOLRecip As Object
Dim iRow As Integer
Dim sRec As String, s
Sub As String, sBody As String
Dim ClpObj As DataObject
Set ClpObj = New DataObject
Set oOL = CreateObject("Outlook.Application")
sRec = ActiveSheet.Range("S1").Value
s
Sub = "Titel"
Set oOLMsg = oOL.CreateItem(0)
With oOLMsg
Set oOLRecip = .Recipients.Add(sRec)
.Subject = Cells(1, 15).Value & " - Titel 'anpassen
'Zwischenablage wird eingefügt
ClpObj.GetFromClipboard
.Body = ClpObj.GetText(1)
.Body = "Hallo " & Cells(1, 17).Value & "," & vbCrLf & vbCrLf & _
"........" & vbCrLf & _
"........." & vbCrLf & _
vbCrLf & ClpObj.GetText(1) & vbCrLf & vbCrLf & _
"........." & vbCrLf & vbCrLf & _
vbCrLf & "Mit freundlichen Grüßen" & _
vbCrLf & "......" & vbCrLf & vbCrLf
.attachments.Add "P:\Dateien....pdf"
.Display
'.send
SendKeys "%s", True
Application.Wait (Now + TimeValue("0:00:02"))
oOLRecip.Resolve
End With
Set oOL = Nothing
End Sub