add date to the file name in subject line

B

Bleeno

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.
 
K

Ken Snell

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
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.
 
B

Bleeno

Thanks!!! Worked fine. I just wasn't thinking that way. I makeing it more dificult that what it was.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top