add date to the file name in subject line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I add the date to the file name on the subject line when using the sendobect commanad within macros. I know =Now() will show the date but I would like to concatenate the two items. Then I also need to change the date format to short.
 
Not sure which argument you want to use, but this is a generic way of doing
what you want:

="Filename" & Format(Date(), "Short Date") & "More Text"

--
Ken Snell
<MS ACCESS MVP>

Bleeno said:
How would I add the date to the file name on the subject line when using
Click to expand...
the sendobect commanad within macros. I know =Now() will show the date but I
would like to concatenate the two items. Then I also need to change the date
format to short.
 
Thanks!!! Worked fine. I just wasn't thinking that way. I makeing it more dificult that what it was.
 
Back
Top