Help with flagging records after an email gets sent...

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I have an Admissions for Faculty of Medicine database
that is due to go online next year...with the tables
residing on a server and the frontend for the
Administrative side still using the Access 2000 forms.

Here is an example of something the Admin side needs
after the applicants submit the application.

When the fee payment for admission comes to the office
through the mail...the data entry person finds the
applicant and checks the Fee Paid checkbox and enters the
Date Received textbox...
THEN they want to send an email acknowledging that they
have received the applicants payment.

Problem...not doing this 1 time only...if 5 payments come
in today...they want to send 5 emails today...if 5 more
applicants send fees the next day...want that email
mesage to go to those 5...

How can I...run a report or something (I know that part)
to
find the applicants whose fees have been received for
that day and send the email?

2nd...what can I set up on a form showing that a
particular person was already sent the letter...so that
they don't get it sent again???
.....and 2
 
You might try a couple of things. One is to have the date
that the payment was received entered automatically when
the checkbox is clicked. (this would prevent users from
entering an incorrect date) Next you might want to
consider sending the email, after confirmation from user
to send, when the checkbox is clicked or some other
action on the form.

Byron
 
Thanks Byron...

Once the checkbox and date are entered...do you know how
to send an email message to the people who's payments
have been received that day?

And then...I will need to do the same thing the next
day....make sure that the previous people do not get an
email resent to them.

I have to have something set up afterwards that will show
the data entry person that an email has already been sent
to the applicant.
 
I actually had in mind that you would send the email
immediately when the checkbox is checked. I also would
ask the user if they wanted to send the email. Then if
they said NO, I would uncheck the check box, remove the
date that had been entered and inform the user that the
email has to be sent if the payment has been received.

Check out the Knowledge Base for sending email from
Access. I have some code that will work if you cannot
find it.

If need be, you can contact me directly at: mrbpolk@cox-
internet.com

Byron
 
Back
Top