Adding a Reminder Time Via Vbscript to outlook

Posted on 2010-01-06
Last Modified: 2012-05-08
I have a solution for adding the due date at this post:

Now I want to do the same thing but add a reminder time: The data I get from the accounting software is like 20100106

I am using the above link formula to covert to outlook time but how do I also add a time to that. The time I wan't to add will always be 10:00 AM

Here is the reminder time code that works:

reminderTime = dateserial(left("20100108",4),mid("20100108", 5, 2),mid("20100108",7,2))

Now I wan't to add the 10:00AM somehow

Question by:badgermike
    LVL 15

    Author Comment

    In my 3rd sentance, I meant I am using the above link to convert the date (not time)...I just want to add 10:00am to it.

    LVL 59

    Accepted Solution

    Hello badgermike,

    Do you mean:

    dateserial(left("20100108",4),mid("20100108", 5, 2),mid("20100108",7,2)) + timevalue("10:00") or
    Format(dateserial(left("20100108",4),mid("20100108", 5, 2),mid("20100108",7,2)) + timevalue("10:10"), "ddddd h:nn AMPM")



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Use email signature images to promote corporate certifications and industry awards.
    Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now