Many Expiration Dates in Custom Form

Status
Not open for further replies.

credogal

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Hello,

I have created quite a detailed form, but I have about 150 different expiration dates that I need to keep track of. What I would really like to do, is have a reminder pop-up for each date 30 days prior to expiration, so that I can get the correct paperwork sent out, etc.

I am really using this as a database, but I wanted to be able to drag emails and documents into a note section, so even though I probably am not using it properly, it works -- except having reminders (it would be really hard to keep track of 150 expiring dates for 100 people).

I'm not a programmer (like you couldn't tell), but would really appreciate some help!

Thank you!

Kris
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Do you have 150 dates in one form or 150 forms?

You'd need to either create tasks with reminders (could do it using VBA) or use VBA to 'watch' the fields and trigger a popup. I'm not sure which would be easier - maybe VBA that walks the folder and creates tasks for upcoming dates... that would eliminate some of the task clutter. Unfortunately, I don't have code samples that do any of that.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 14
B Task Filter Not Working When I add too many criteria Using Outlook 0
T Many problems with outlook.com - will upgrade to Outlook soon Using Outlook 1
D Too many scripts? Outlook VBA and Custom Forms 1
GregS Outlook 2016 Too Many Archives Using Outlook 0
GregS Many Sent Item folders Using Outlook 3
P how to remove unwanted PST file default categories assigned to many calendar entries Using Outlook 7
L Why do i get so many drafts? Using Outlook 12
T Received many email without information Using Outlook 1
M How many days are items in Recover Deleted at Outlook.com ? Using Outlook.com accounts in Outlook 4
O Copy mails from many subfolders to 1 foldr Using Outlook 2
C too many choices for time zones! can i reduce to actual time zones only? Using Outlook 1
M warning for too many appointments on a same day in Outlook Using Outlook 1
M Charter ISP Claims Outlook Generating STMP Errors of Too Many Recipients Using Outlook 1
D Meeting Request - Too Many Recipients Using Outlook 0
Diane Poremsky "Too many files" Error Message New Slipstick.com Articles 0
O W-a-a-y too many PSTs (Outlook 2003) Using Outlook 0
I Many empty Contacts folders.. cannot get rid of them Using Outlook 4
A Importing too many emails from Gmail Using Outlook 2
P How many subs can run in one outlook VBA script Using Outlook 5
R Many folders Using Outlook 11
R Rules - many or few Using Outlook 10
mikecox Too many "contacts" lists Using Outlook 2
S Setup many personal calendars on outlook 2013 on new laptop- starting over Using Outlook 1
W Outlook 2010 has many inbox folders Using Outlook 5
T Public Folder has many messages but can't be seen in Outlook Using Outlook 3
R How many seconds usually takes an email to get to an outlook account? Using Outlook 0
J Want ONE inbox MANY accounts Using Outlook 2
R Too Many Devices Using Outlook 2
C BCC - How many email address will it accomodate? Using Outlook 2
R Too many folders in Outlook 2013 Using Outlook 11
D Navigate to my calendar. Too many steps Exchange Server Administration 2
B Problem with fix for "Too Many Contact Folders" Using Outlook 3
B [outlook-users] Re: Why have I gotten to many "reminders" for birthdays that "occurred" on Jan. 1??? Using Outlook 3
M Outlook 2010 is loading many times already received emails from external acc. Using Outlook 4
C Updating many contacts at once? BCM (Business Contact Manager) 3
D How Many Exchange Accounts in Outlook? Exchange Server Administration 3
B Too many ' tasks' when checking email Using Outlook 1
G How many contacts can be imported into BCM BCM (Business Contact Manager) 1
X If you change expiration date of repeated task it dupplicates Using Outlook 1
V Why is "Value Required" checkbox greyed out for Dates? Outlook VBA and Custom Forms 2
L dynamic and static dates in Outlook contact "notes" ie. body Using Outlook 2
I Help with dates in task list. Using Outlook 5
Z Outlook for G Suite emails showing wrong dates Using Outlook 4
Z Outlook 2013 Gmail IMPA emails not showing dates only showing times Using Outlook 1
J Outlook 2013 Extract Flag Completed dates to Excel Macro Outlook VBA and Custom Forms 16
O Outlook 2016 follow-up flags--how can I add dates? Using Outlook 1
L Entering dates in Contacts and Calendar Using Outlook 4
O highlighted dates in Yearly View for Outlook 2010 Using Outlook 1
B Extract Dates for Appointment Item in Body of email Outlook VBA and Custom Forms 10

Similar threads

Top