Add date to email from Access 1

[secretcrowds]

Hello

I have a command button that fires up an email from a form, but i want the email to automatically insert the date.

I have this line of code:
strBody = strBody & "Attatched below are a list of completed audits *date inserted here*"

I tried this code:
strBody = strBody & "Attatched below are a list of completed audits =Date()"

but to no avail.

help needed.
thanks guys!!

"secret crowds rise up and gather

 

[PHV]

strBody = strBody & "Attatched below are a list of completed audits = " & Date

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[secretcrowds]

nice one! cheers

"secret crowds rise up and gather