date in subjectline for automated email

[Parasyke]

I'm needing to place today's date in the subject line of an email using
the following example:

DoCmd.SendObjec t acSendReport, "This Is My Subject Line", acFormatRTF,
_

Can anyone show me how to place the date so that it reads: This Is My
Subject Line - 09/15/2006 (?)

Thanks in advance!

[pietlinden]

Parasyke wrote:

I'm needing to place today's date in the subject line of an email using
the following example:

DoCmd.SendObjec t acSendReport, "This Is My Subject Line", acFormatRTF,
_

Can anyone show me how to place the date so that it reads: This Is My
Subject Line - 09/15/2006 (?)

Thanks in advance!

"Some subject - " & format(date,"mm/dd/yyyy")

read up on Format in Help. (if you're like MLH, it's carefully hidden
under the F1 key)

[Parasyke]

Thanks, this worked... is it possible to pass this data into the name
of the attached report? Here's my block of code:

DoCmd.SendObjec t acSendReport, "NameOfMyReport ", acFormatRTF, _
"EC*******@jugg ernaut.com", , , _
"NameOfMyReport : " & Format(Date, "mm/dd/yyyy") & " """ &
Forms!MyForm.My textbox & """", , False

the subject line reads correctly: NameOfMyReport: 09/15/2006 "Joe
Employee"

I would just like to pass the employee name and date into the name of
the attachment.. is this possible?
Thanks so much!
pi********@hotm ail.com wrote:

Parasyke wrote:

I'm needing to place today's date in the subject line of an email using
the following example:

DoCmd.SendObjec t acSendReport, "This Is My Subject Line", acFormatRTF,
_

Can anyone show me how to place the date so that it reads: This Is My
Subject Line - 09/15/2006 (?)

Thanks in advance!

"Some subject - " & format(date,"mm/dd/yyyy")

read up on Format in Help. (if you're like MLH, it's carefully hidden
under the F1 key)