How can I add the current date in the subject of an email created in Access?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ejohansen
    New Member
    • Feb 2015
    • 1

    How can I add the current date in the subject of an email created in Access?

    I am trying to edit a macro in Access that would add the today's current date on the string already in the subject line?
  • twinnyfo
    Recognized Expert Moderator Specialist
    • Nov 2011
    • 3653

    #2
    Try this:

    Code:
    strSubject = strSubject & Format(Date, "dd mmm yyy")
    Hope this hepps!

    Comment

    Working...