Hallo,
ein kleiner
Versuch zum Testen.
Button E-Mail senden, leere Zellen ausfüllen.
Gruß
fedjo
Sub Tabelle_senden()
If Sheets("Tabelle1").Range("A1") = "" Then
MsgBox "Bitte A1 ausfüllen!"
Sheets("Tabelle1").Range("A1").Select
Exit Sub
End If
If Sheets("Tabelle1").Range("B1") = "" Then
MsgBox "Bitte B1 ausfüllen!"
Sheets("Tabelle1").Range("B1").Select
Exit Sub
End If
If Sheets("Tabelle1").Range("C1") = "" Then
MsgBox "Bitte C1 ausfüllen!"
Sheets("Tabelle1").Range("C1").Select
Exit Sub
End If
If MsgBox("Soll das aktuelle Tabellenblatt als E-Mail versendet werden?", vbOKCancel) = vbOK Then
Application.DisplayAlerts = False
Dim aws As String
Dim olapp As Object
ActiveWorkbook.ActiveSheet.Copy
ActiveWorkbook.Save
aws = ActiveWorkbook.FullName
Set olapp = CreateObject("Outlook.Application")
With olapp.CreateItem(0)
.to = "" 'E-Mail einfügen
.htmlbody = "Hallo "
.Subject = "Formular"
.Attachments.Add aws
.display
'.send
End With
Set olapp = Nothing
Application.DisplayAlerts = True
ActiveWorkbook.Close SaveChanges = False
Kill aws
End If
End Sub