I want to add a message and the date when ever I open an email template I have saved.
I could only manage to get to the below bit of code:
Private Sub adddate() .Item.Subject = "Prep Status Report " & Format(Date, "dd/MM/yyyy") End Sub
How can I improve this so that it works as intended.
The subject line should read :
Prep Status Report 10/12/2018 if run on 10th December