Solved

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

Posted on 2011-03-09
3
477 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Calendar item that should send reminder to users. 1 36
Connection Refused Errors on Exchange 2007 part of SBS 2008 10 25
exchange, outlook 8 52
exchange, outlook 7 38
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this video we show how to create a Contact 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 Recipients >> Contact ta…
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …

937 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now