How to Auto Insert Current Date or Time into Email Subject or Body with Outlook VBA

Many users are used to inserting the current date or time into the email subject or body when composing a new email. This article will teach you how to achieve it in quick time.

In the previous post – “How to Auto Add Current Date to the Subjects of Your Outlook Emails”, you can learn how to auto add the current date or time to the subject. But the method in that post is simply to create a custom form of message. Thus, by that means, every time you want to create a new email with the current date or time in subject, you have to choose the custom form instead of creating a new email as usual. Obviously, it will be quite cumbersome.

Actually, Outlook has already offered us a native field to insert date or time. Also, you can apply Outlook VBA to auto insert the current date or time into the new email’s body or subject. As for which method you select, it depends on how often you need to insert the date or time.

Manually Insert by “Date & Time” Field

  1. To start with, launch Outlook.
  2. Then create a new message by clicking “New Email” button in “New” group under the “Home” tab.
  3. Subsequently, in the New Message window, you can click into the email body and turn to “Insert” tab.
  4. Next you can find and click the “Date & Time” field in “Text” group.Find Date & Time Field
  5. After that, a new dialog box will show up. You can choose an available format and then click “OK” button.Select Format for Date and Time
  6. After returning to the message window, you can see the current date or time in the email body. By default, Outlook doesn’t permit you to apply the “Date & Time” field to the subject.Current Date or Time in Message Body
  7. Hence, finally, if you want to insert the date or time to subject, you have to copy them from the body and paste them to the subject manually.

This method is more recommended if you seldom need to insert the current date or time. But provided that you frequently or always need to insert, you had better use the following VBA codes to achieve it automatically.

Auto Insert with Outlook VBA

  1. In the first place, press “Alt + F11” key buttons to access VBA editor.
  2. Then double click the “ThisOutlookSession” project on the left side to open it.
  3. Next copy the following codes into it.
Public WithEvents objInspectors As Inspectors
Public WithEvents objMail As MailItem

Private Sub Initialize_handlers()
    Set objInspectors = Application.Inspectors
End Sub

Private Sub objInspectors_NewInspector(ByVal Inspector As Inspector)
    If TypeOf Inspector.CurrentItem Is MailItem Then
       Set objMail = Inspector.CurrentItem
    End If
End Sub

Private Sub objMail_Open(Cancel As Boolean)
    Dim strTime As String
 
    'the current time
    strTime = Now
 
    'insert to subject
    'If you don't want to insert to subject, remove the following line
    objMail.Subject = strTime
    'insert to body
    'If you don't want to insert to body, remove the following line
    objMail.Body = strTime & objMail.Body
End Sub

VBA Codes - Auto Insert Current Date or Time into Email Subject or Body

Note: The above codes will work to auto insert the current time into the subject and body. If you want to insert the current date, replace the “objMail_Open” sub with the followings:

Private Sub objMail_Open(Cancel As Boolean)
    Dim strDate As String
 
    'the current date
    strDate = Date
 
    'insert to subject
    objMail.Subject = strDate
    'insert to body
    objMail.Body = strDate & objMail.Body
End Sub
  1. Subsequently, sign this code as usual.
  2. Later, restart Outlook to activate the macro.
  3. Finally you can have a try.
  • Directly click on the “New Email” button to open a new email.New Email
  • You will find that the new email auto contains the current date or time in the subject and body, like the image below:Current Date or Time in Message Subject or Body

Don’t Trust in Unknown Emails Readily

You must have ever received junk emails. How do you usually deal with them? It is inadvisable to download attachments or open links in this kind of mails in that they may contain viruses. Once your Outlook data gets infected, the inbox repair tool, Scanpst.exe won’t make effects. In this case, you have no choice but to resort to a more experienced PST fix tool, such as DataNumen Outlook Repair.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including corrupted SQL Server and outlook repair software products. For more information visit www.datanumen.com

3 responses to “How to Auto Insert Current Date or Time into Email Subject or Body with Outlook VBA”

  1. When you first obtain to the website, you can obtain acquainted with it aesthetically, yet you will not be able to get and browse profiles to understand without registering on LatamDate. Making use of the search standards you can choose the profiles you need. We recommend you to load it to the optimum due to the fact that then the look for a partner will certainly be a lot more comprehensive. Need to know more concerning the top quality of accounts? Simply surf them; we make sure a few minutes will be enough. Though it is terrific that the accounts include real-life images of ladies, it would certainly be excellent if there will certainly be much more personal web content from women, particularly video clips. Likewise, some customers want to see more candid photos of sensational women – this is the objective perspective of some users we found on SiteJabber. Can I watch accounts without signing up? There is even a feature of picking profiles according to your horoscope.

    If you are on the go or have a break at work, this is an excellent opportunity not to quit chatting with girls also. So, also if there are extra men than women below, you won’t feel it as an issue. After signing up on the site, you can fill in your survey in a lot more information. After registering on the site, you obtain modern-day communication chances that will certainly make your interaction extraordinary, very easy and also delightful. It deserves $9.99 monthly, yet you can obtain the first month for complimentary with an acquisition of credit histories. You might spend for credit scores by utilizing a charge card just. There are a couple of credit plans on LatamDate – as common, the larger package you acquire, the less 1 credit history costs. These are girls who await enjoyable communication as well as creating a family members. Singles who choose the old-fashioned love letter can make use of specific mail forwarding.

    It is easy to locate your love right here, because on a daily basis brand-new customers are registered on the site. While most of info you can acquire via connecting with your date, it is also feasible to figure out something about her life with account details. Each user can get expert advice immediately. The website makes sure that the user profile, contact info, and also payment information are private. If you intend to contact her right now, you will certainly see a large green Chat Currently button. You simply need to register on the site if you are attracted by unstable and passionate Latin ladies and you desire such a woman to become yours. Exactly how to sign up after that? A dating website supplies a common means to register via email. LatamDate does not have a lot in the means of sex selection and also does not accommodate any individual various other than heterosexuals or homosexuals. You simply enter your name, email address, day of birth, as well as sex to produce a cost-free account.

    When it concerns profile top quality, photos, and also videos, LatamDate is a complimentary website. At the click of a computer mouse, a full profile opens up. Details in the account can be watched just by those who have actually signed up on the website. Last but not least, it is vital to discuss that upon registration, each and every single account needs to be verified. Mostly all female users desire to get accustomed with a man just to travel. You can be certain that you will find your excellent new bride since of the amount of female accounts on this web site. You’re totally free to surf the profiles of Latina females! Besides, you will certainly have sufficient time to try the website as a complimentary individual before carrying out any payments. Though this online dating website has rather many totally free features (we’ll detail them all below), the most helpful functions are exceptional ones. Furthermore, companies are the ones that provide services and produce ladies’s accounts – not women themselves. The authenticity of ladies’ accounts are mainly in the control of the firms. Site stats are available at any moment. The global dating site LatamDate has existed for more than 10 years as well as during this moment has actually acquired a remarkable audience in all parts of the world.

  2. There is also an alternative called Admirer mail, but we will cover it later on in the CharmDate evaluation! There’s no particular alternative of becoming confidential, yet members can indicate a false name. Users can make use of the search device to filter their search based upon certain requirements. You can utilize the CamShare alternative that will allow you to use your cam and interact with fascinating girls and see them in real-time. You will hence have to upgrade to exceptional subscription to utilize them. And also your cherished will obtain a surprise from you. There isn’t any better means to impress a woman than make initiatives to surprise her. If there was false info provided against you that led to the ban, it can be done. It took about one min to produce, supplying a minimum quantity of details. They publish rates of usage, for instance, one debt, which at the most affordable fare is Usdlr 4, is intended to last for 10 minutes in the conversation, their advertising specifies that the price is 0,50 debts for five minutes, yet they grossly overcharge not only on the worths of the chats, yet in the phone call, and the video clip usage.

    If you haven’t been connecting with somebody for the last six months, her get in touch with is erased. Possibly they located a person they wish to date offline, or perhaps they’re simply not interested in on the internet dating anymore. When a video can be found in turn, since the male wishes to see the lady, the website, Charmdate, provides a video clip formerly movie of the girl as well as the worker does the writing of the conversation, when and also if the guy desires to see her standing up, or desires to confirm her legitimacy, they quit the video clip, makes reasons, that the internet is not working etc and so on, This particular people are experts on this circumstances, I do comprehend this is a service and also this people, their owners, can run it as they intend to, however something is run a good website, one more is scam individuals by acting he touches with a woman and he is not. This sort of natural environment-friendly or blue eyes are caring as well as bright, which can conveniently make people deeply engaged. There might be phony profiles, but you will know if customers are genuine because you speak to them over the phone or video clip chat after.

    There is just one option that is called Admirer mail that permits you to receive messages from women without paying, however you would certainly not be able to respond to them! The 3rd choice allows you to receive phone calls from all girls from your call checklist. So in situation you want to date a terrific lady, prepare yourself to purchase credit scores given that without them you would not have the ability to connect with beautiful ladies. Application is available for various tools and if you do not wish to install this software application you can still talk using your Smart device. For that reason you do not have actually to be bothered, just remain tranquil and sign in to the site. Indeed, easy design and user-friendly user interface are the reasons that numerous new members stay on the site. The internet site style is straightforward, yet it doesn’t make it look mediocre. Considering that this website has actually lasted for twenty years now, it has actually ended up being much more experienced at matching on-line relationships.

    The really reality that it has actually been functioning for greater than 20 years is a fantastic reason to recognize exactly how efficient as well as expert this site is. I have created and also issue to them not least than 12/14 times, and also they come back, with letters, well made, by their attorneys, which they have great ones, they recognize that they are working unlawfully as well as scamming individuals, with no answers but just wonderful words, and no options. Czech women have obtained a good education, they have an open attitude to enjoy and marital relationship, they have a strong passion in guys from the USA, Britain, France, Germany and also other countries, they are not money grubbing for western wealth, but from a forgiving as well as open perspective to culture. CharmDate represents an on the internet dating service of superior top quality for single guys who are wanting to dating girls from Russia and also Ukraine. There are in this website some ladies that are genuinely looking for somebody however should of them are phonies. There is a bundle with 100 credit histories that will certainly allow you to save a lot of money since the rate per credit history will be lower. If you do not need to invest a lot of cash, you can simply pick a smaller sized package with credit scores.

Leave a Reply

Your email address will not be published. Required fields are marked *