View Single Post
  #5  
Old January 20th 06, 05:59 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default Automatically Email Daily Reports Using Outlook.

Am 19 Jan 2006 06:37:03 -0800 schrieb chimp:



Additionally, what is the proper syntax to use to have the subject line
of the email read:

"1/19/06 Destination Details Report"

where 1/19/06 is derived from the current date. I tried using the date
function in several different ways:

.Subject = "Destination Details Report" str=Format(Date,
"mm/dd/yy")

Is it possible to add the date in the .Subject line?


Strings are being joined by the ampersand:

Subject = Format(..) & "more text"

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Ads