Append Date and Time to the Subject of an email (objEmail.subject)
Posted on 2011-03-09
Good afternoon. I would like to add the date and time to the subject line of an e-mail generated by a webpage form. Currently, I have updated the objEmail.subject line to be:
objEMail.subject = "Inquiry from Ask The Experts Section. " & Mid(Now(),1,InStr(1,Now(),":"))
I get an e-mail with the following subject: Inquiry from Ask The Experts Section. 3/9/2011 11:
What do I need to change to get the rest of the time? If I remove the :, I get no time at all. The time format should be 11:52 AM or something similar.
Alternatively, I have tried to use an Exchange transport rule to append the date/time to the subject line of an e-mail addressed to this specific user. I could not find a solution using transport rules, so I am open to other suggestions on the Exchange 2007end.