Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
add 2nd Name and Date to Code
On Error Resume Next
With OutMail .To = ") .CC = "" .BCC = "" .Subject = " Stats for " & text(date, "mm/dd/yyyy") Wanna Learn wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
add 2nd Name and Date to Code
Whoops!
Use: .Subject = " Stats for " & Format(date, "mm/dd/yyyy") =text() is a worksheet function. Format is the VBA function. Dave Peterson wrote: On Error Resume Next With OutMail .To = ") .CC = "" .BCC = "" .Subject = " Stats for " & text(date, "mm/dd/yyyy") Wanna Learn wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date code validation | Excel Discussion (Misc queries) | |||
Date Function and Color Code | Excel Worksheet Functions | |||
Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
date format in code | Excel Discussion (Misc queries) | |||
Date Code | Excel Discussion (Misc queries) |