add 2nd Name and Date to Code

W

Wanna Learn

Hi I copied this code from Ron de Bruins site everything was fine until I
tried to add a 2nd name to the TO: field and to the subject line I want to
add todays date

below is the part of the code that I need help with thanks in advance


On Error Resume Next
With OutMail
.To = " I WANT TO ADD 2 NAMES HERE"
.CC = ""
.BCC = ""
.Subject = " Stats for" here I WANT TO ADD TODAY'S DATE
 
D

Dave Peterson

Whoops!

Use:

.Subject = " Stats for " & Format(date, "mm/dd/yyyy")

=text() is a worksheet function. Format is the VBA function.
 
Top