Reminder

  • Thread starter Thread starter shany0
  • Start date Start date
S

shany0

Help is needed !

I have to create a database in Excel of people that will look like:

A B C D

NAME, ADDRESS, DATE OF BIRTH, TELEPHONE NO.

A= NAME
B= ADDRESS
C= DATE OF BIRTH
D=TELEPHONE NO.
And so on.

I would like to generate a pop-up that will act 2 days before the
person's birthday , and will send an automatic email message to myself
as a remminder of client's birthday.
Is there any way to create a formula that will answer my requirments?

I must remark that I am not a programmer and I would need instruction,
where I should install a program/formula like that.

Thanks in advance,

Shany
 
Shany
What you want will require VBA (programming). If you wish, I'll be glad
to work with you to develop a suitable program. I will need additional
information from you first.
You say 2 days.
Do you want to be reminded again when it is only 1 day?
Do you mean 2 workdays? IOW, do you want to be reminded on Thursday that a
birthday is on Monday?
Do you open this birthday database file every day? Every workday?
Do you run Excel every day? Every workday?
You say that you want a message box displayed and an email sent. Would a
message box and a printout suffice?
Tell me the full path to your birthday database file. The full path.
Including the name of the file.
You can post the above information on the newsgroup (NG), in the same
thread, if you wish, but I will need an email address to which I can send a
file or files as I develop the thing. Attaching files to a NG post is
frowned upon. My email address is (e-mail address removed). Remove
cobia97 from this address. HTH Otto
 
Back
Top