e mail same body different subject

  • Thread starter Thread starter Marilyn
  • Start date Start date
M

Marilyn

Hello I copied the code below. Now is it possible to change the line
Subj = "Your Annual Bonus"
Here is the thing, the body of the e mail will be the same for
everyone but the subject will be different. How do I do that? thanks

Sub SendEmail()
Dim cell As Range
Dim Subj As String
Dim EmailAddr As String
Dim Recipient As String
Dim Bonus As String
Dim Msg As String
Dim HLink As String
For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "*@*" Then
'Get the data
Subj = "Your Annual Bonus"
Recipient = cell.Offset(0, -1).Value
EmailAddr = cell.Value
Bonus = Format(cell.Offset(0, 1).Value, "$0,000.")V
 
Back
Top