03.12.2020, 08:10 (Dieser Beitrag wurde zuletzt bearbeitet: 03.12.2020, 08:10 von Kuwer.)
Hallo Frank,
Sub EMailVersand_speichern_Klicken()
Dim i As Long
For i = 2 To Tabelle7.Cells(Rows.Count, 1).End(xlUp).Row
With Worksheets("versendete Mails").Cells(Rows.Count, 1).End(xlUp)
.Offset(1, 0).Value = Tabelle1.Range("B10").Value
.Offset(1, 1).Value = Tabelle1.Range("C13").Value
.Offset(1, 2).Value = Tabelle7.Cells(i, 1).Value 'EMail-Anhang
.Offset(1, 3).Value = Tabelle1.Range("B25").Value
.Offset(1, 4).Value = Tabelle1.Range("B13").Value
.Offset(1, 5).Value = Now
.Offset(1, 6).Value = Tabelle1.Range("B32").Value
End With
Next i
End Sub
Sub EMailVersand_speichern_Klicken()
Dim i As Long
Tabelle1.Range("B10").Value = Now
For i = 2 To Tabelle7.Cells(Rows.Count, 1).End(xlUp).Row
With Worksheets("versendete Mails").Cells(Rows.Count, 1).End(xlUp)
.Offset(1, 0).Value = .Offset(1, 0).Value + i - 2
.Offset(1, 1).Value = Tabelle1.Range("C13").Value
.Offset(1, 2).Value = Tabelle7.Cells(i, 1).Value 'EMail-Anhang
.Offset(1, 3).Value = Tabelle1.Range("B25").Value
.Offset(1, 4).Value = Tabelle1.Range("B13").Value
.Offset(1, 5).Value = Now
.Offset(1, 6).Value = Tabelle1.Range("B32").Value
End With
Next i
End Sub
Sub Rechnungsversand_Schaltfläche54_Klicken()
Dim i As Long, j As Date
j = Now
For i = 2 To Tabelle8.Cells(Rows.Count, 1).End(xlUp).Row
With Worksheets("versendete Mails").Cells(Rows.Count, 1).End(xlUp)
.Offset(1, 0).Value = Format(j, "yyyymmddhhnnss") & Format(i - 1, "_00")
.Offset(1, 1).Value = Tabelle1.Range("C13").Value
.Offset(1, 2).Value = Tabelle1.Range("C14").Value 'EMail-Anhang
.Offset(1, 3).Value = Tabelle1.Range("B25").Value
.Offset(1, 4).Value = Tabelle8.Cells(i, 1).Value
.Offset(1, 5).Value = Now
.Offset(1, 6).Value = Tabelle1.Range("B32").Value
End With
Next i
End SubGruß Uwe