[MS Office - 2003] Email query result from Access

[SYNACK]

Ah, yes I messed up it should be:

stSubject = "EMAIL SUBJECT on " & Day(Now()) & "/" & Month(Now()) & "/" & Year(Now())

if that gives an error try just Now rather than Now() in the brackets. The other method should go though and is probably a bit cleaner

[RabbieBurns]

yea, the

stSubject = "EMAIL SUBJECT on " &  Format(Date, "dd/mm/yyyy")

works a treat..

many thanks