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.
Thread starter Similar threads Forum Replies Date
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 13
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
D Outlook 2010 error - you are attempting to attach too many files at once Using Outlook 11
R When I try to send an email to many people, I receive the following error message: (0x8004010F): The Using Outlook 1
C 452 4.1 1. requested action aborted:try again later, too many recipients Using Outlook 4
R Too many inboxes Outlook 2010 Using Outlook 2
J Too many email folders on MSN issue. Migrate to Outlook? Using Outlook 3
M Problem with Outlook 2007 - hotmail not coming in, difficulties sending out, many many other problems Using Outlook 4
J Re: Outlook 2010: The task list is empty in the to do bar but there are many tasks there. Using Outlook 4
G Re: Outlook 2010: The task list is empty in the to do bar but there are many tasks there. Using Outlook 1
K How many old e-mails can Outlook 2010 store, access, and manage? Megabytes or Gigabytes? Using Outlook 2
S Views on frequently updated public folders in Outlook 2003 for many users Using Outlook 1
C Cannot start Outlook, prompted with “too many failed open attempts” error Can’t find my name in the Microsoft server, what do I do. Using Outlook 2
H Too Many Names error when configuring new account in Outlook Using Outlook 3
Similar threads


















































Top