mikeo1313
05-11-2010, 01:04 PM
I found links on how to made a drop down list in access & how to make a send email button but now I'm stuck. Imagine theres a PEOPLE table with a checkbox for each record and you have about 10 custom messages to send to each in various moments. You have a separate table just to stamp the message button you pressed with the time & date, to keep track.
IMO, that checkbox is a handy way to make this as simple as possible. Its the multiple send email button(s) that will:
a. loop through for the check box
b. get the persons email from another table
c. stamp to activity table the date&time + write associated PEOPLEID FK and finally
d. reset checkbox when done.
Please assume db structure is well so I can start plowing through this one.
IMO, that checkbox is a handy way to make this as simple as possible. Its the multiple send email button(s) that will:
a. loop through for the check box
b. get the persons email from another table
c. stamp to activity table the date&time + write associated PEOPLEID FK and finally
d. reset checkbox when done.
Please assume db structure is well so I can start plowing through this one.