=today() or =date() in Email?

[TrippyTom]

Is there something for Outlook that I can use to insert the current date/time in an email template before I send it out? I've created a template and would like to send clients a friendly ETA notification for new project requests.

 

[nbrcrunch]

Outlook auto-stamps (date & time) every email--so I am confused by your question.

 

[TrippyTom]

I want to put it INSIDE the template. Here's what it looks like:

Regarding your project: The time is now [@now].

I estimate completion of this project within ____ to ____ hours/minutes. Please contact me at the number below if you have any questions.

Thank you,

[edit] -- Since this posting, I don't have to do this anymore, but I would still like to know if it's possible.

 

[NateO]

Hello,

Are you using code to send the e-mail? If so, post your Subject-line code. Basically, you Concated Date to the string, e.g.,

MsgBox "Today's date is: " & Date

If you want Date & Time, use Now, e.g.,

MsgBox "The date & time is: " & Now

Or, are you using worksheet functions? These are volatile, so they'll update on Recalc...