View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default add 2nd Name and Date to Code

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