Solved

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

Posted on 2011-03-09
3
498 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
To show how to generate a certificate request 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 Servers >> Certificates…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

726 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