Excel VBA Now + TIME() ?

[theta]

I have been using RonDeBruin mail macro (very nice). Now I am adding a reminder to the mail. Which does work, but the timings do not!

Whenever I send, it pops up instantly saying due NOW, when it should be the current time + time()

Any ideas?

        .ReminderSet = True
        .ReminderTime = Now + Time(1, 0, 0)
        .DueDate = Now + Time(8, 0, 0)

 

[VoG]

Try

.ReminderTime = Now + TimeSerial(1, 0, 0)
.DueDate = Now + TimeSerial(8, 0, 0)

 

[theta]

Thanks

 

[theta]

If the recipient has outlook, will this give them reminders? I want the mail to prompt people at certain times...