Solved

Append Date and Time to the Subject of an email (objEmail.subject)

Posted on 2011-03-09
3
493 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:dangoforth
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
wdosanjos earned 125 total points
ID: 35085710
Please try this:

    objEMail.subject = "Inquiry from Ask The Experts Section. " & Now()
0
 
LVL 1

Author Comment

by:dangoforth
ID: 35085745
wdosanjos

Tried it and I get a subject line that says "False".
0
 
LVL 1

Author Comment

by:dangoforth
ID: 35085770
wdosanjos

Sorry - typo. Your suggestion worked well. Anyone want to weigh in on the Exchange side?
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to install and use the NTBackup utility that comes with Windows Server.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question