Reminder Time and Reminder Validation

Status
Not open for further replies.
S

srm

I'm using Outlook 2003. Before a I click on Save (custom task form), I

want to be prompted that if I have a Reminder time, I need to also

check the Reminder field. I have the following validation formula, but

I get prompted no matter if the reminder field is checked or not

checked or if the reminder is none and the reminder is not checked.

([Reminder Time] <> "None") And ([Reminder] = "Off")

I tried different variations but still cannot get it to work where I

have a reminder time, but not the reminder field checked and for it to

prompt upon Save.

Thanks

Shawn
 
What kind of prompt do you want? A validation formula doesn't give you a

"the data looks like this -- do you want to save anyway?" prompt. It simply

prevents Outlook from saving the item .

Note that a validation formula must return True if the data is "good" and

False if the data is "bad." Also, the Reminder field can have a Boolean

value of True or False, not "Off" or "True," which are strings.

Sue Mosher

"srm" <srm@primatech.com> wrote in message

news:723ef5de-792a-406b-850f-66b0790bb278@31g2000vbf.googlegroups.com...
> I'm using Outlook 2003. Before a I click on Save (custom task form), I
> want to be prompted that if I have a Reminder time, I need to also
> check the Reminder field. I have the following validation formula, but
> I get prompted no matter if the reminder field is checked or not
> checked or if the reminder is none and the reminder is not checked.

> ([Reminder Time] <> "None") And ([Reminder] = "Off")

> I tried different variations but still cannot get it to work where I
> have a reminder time, but not the reminder field checked and for it to
> prompt upon Save.

> Thanks

> Shawn
 
On Nov 24, 1:54 pm, "Sue Mosher [MVP]" <sue...@gmail.com> wrote:
> What kind of prompt do you want? A validation formula doesn't give you a
> "the data looks like this -- do you want to save anyway?" prompt. It simply
> prevents Outlook from saving the item .

> Note that a validation formula must return True if the data is "good" and
> False if the data is "bad."  Also, the Reminder field can have a Boolean
> value of True or False, not "Off" or "True," which are strings.
> > Sue Mosher
>    >      >    
> "srm" <s...@primatech.com> wrote in message

> news:723ef5de-792a-406b-850f-66b0790bb278@31g2000vbf.googlegroups.com...
>
> > I'm using Outlook 2003. Before a I click on Save (custom task form), I
> > want to be prompted that if I have a Reminder time, I need to also
> > check the Reminder field. I have the following validation formula, but
> > I get prompted no matter if the reminder field is checked or not
> > checked or if the reminder is none and the reminder is not checked.

>
> > ([Reminder Time] <> "None") And ([Reminder] = "Off")

>
> > I tried different variations but still cannot get it to work where I
> > have a reminder time, but not the reminder field checked and for it to
> > prompt upon Save.

>
> > Thanks

>
> > Shawn


Sue:

Thank you. With your guidance, I got it to work. Thanks again for all

your help.

Shawn
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
e_a_g_l_e_p_i Is it possible to have a reminder in Outlook 2021 for every 90 days Using Outlook 3
M New Calendar Appointments: Conditionally turn off reminder and show time as free Using Outlook 5
A Reminder duplication Outlook and Outlook.com Using Outlook.com accounts in Outlook 5
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
V Accepted meetings do not get the default reminder Using Outlook 0
S Command Button_Click action on Item/Reminder Outlook VBA and Custom Forms 3
G Arggh, weakness of reminder for every Task recurrence Using Outlook 0
Z Outlook 365 delete reminder you can’t make change to contents of this-read only folder Using Outlook 4
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
F how do i set a reminder in onenote 2010 Using Outlook 8
Q Unable to Sync Quicken reminder with Outlook 2016 64Bit Using Outlook 1
Y Outlook Task View - Table Format - Customize Reminder Time to Drop-Down Selection Using Outlook 2
B resend if no reply and send an automatic reminder Outlook VBA and Custom Forms 0
e_a_g_l_e_p_i Can you set reminder to specific times? Using Outlook 7
A End-time meeting reminder (or "negative" time relative to the meeting start time) Using Outlook 1
M VBA to send reminder email if no response Using Outlook 13
B Change font of reminder of an email header Outlook VBA and Custom Forms 3
O Reminder due end of August is showing up now Using Outlook 2
Witzker Macro to set contact reminder to next day 9:00 Outlook VBA and Custom Forms 45
L Calender reminder emails Using Outlook 3
S Reminder Dialog Open Button Using Outlook 2
F Set (flagged) reminder for next business day Using Outlook 4
D Outlook 2013 changing iCloud reminder time? Using Outlook 0
C Set reminder / appointment by right clicking email Using Outlook 1
L set task reminder date to same as start date (without affecting due date) Using Outlook 0
H send reminder if no reply received on first or original email using macro Using Outlook 2
Diane Poremsky Open a Webpage When a Task Reminder Fires Using Outlook 0
L Fake reminder apperaring (not in calendar) - how to remove? Using Outlook 5
M Messages in Outbox reminder is wrong Using Outlook 4
C Reminder for single-click appointment Using Outlook 2
M Send an Email When a Reminder Fires Outlook VBA and Custom Forms 1
E Send a Reminder/Task to certain Email Recipient Using Outlook 5
Diane Poremsky Send an Email When a Reminder Fires Using Outlook 0
A reminder for every 15 working days Using Outlook 11
Diane Poremsky Setting Custom Reminder Times Using Outlook 0
Diane Poremsky Receive a Reminder When a Message Doesn't Arrive? Using Outlook 10
F e-mail reminder for shared calendar Outlook VBA and Custom Forms 1
K VBA - Prompt for reminder date time Outlook VBA and Custom Forms 7
S Have Rule or Quick Step PROMPT for custom FLAG Due/Reminder date Outlook VBA and Custom Forms 3
A iCloud add-on for Outlook: Reminder for new appointment is set to 'None' by default. How to change? Using Outlook 6
rc4524 Create auto follow-up reminder email for already sent messages Outlook VBA and Custom Forms 1
smokiibear Share Office 365 Tasks such that Other Users also Are Alerted with Reminder Using Outlook 1
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
J Change reminder times of future appointments Using Outlook 1
S PoP up reminder while opening the outlook? Outlook VBA and Custom Forms 1
S Pop up reminder while i close outlook Outlook VBA and Custom Forms 5
H Create a Task by Draft-EMail > Task+Reminder not Working Outlook VBA and Custom Forms 1
D Outlook 2007- old reminder popups Exchange Server Administration 4
2 Email not replied to reminder - aka boomerang? Using Outlook 3
R Problem with Reminder appearing in Inbox Using Outlook 5

Similar threads

Back
Top