M
magmike
I currently have a Yes/No field for each contact titled "newsletter"
that determines whether a contact receives our newsletter or not (we
also have two other periodically sent out items that have check marks
as well that this applies to). However, I want to be able to send a
custom newsletter to people who get it for the first time. It is not
going to be custom for each individual, just to new recievers. In
order to do that I need to capture the date the check box is selected
so I can run a query each month of the "newbies". I thought about
creating a table for this, and then using an OnClick event to enter a
new record in the table with the contact id and the date and time
clicked on. However, I also realize, that if I uncheck it so they
don't receive it, I need to be able to remove them from this table, or
add a new record that shows them as not to send.
As a hack, I thought I would ask for advice on the best design to
accomplish this goal.
Thanks in advance for your help!
Mike
that determines whether a contact receives our newsletter or not (we
also have two other periodically sent out items that have check marks
as well that this applies to). However, I want to be able to send a
custom newsletter to people who get it for the first time. It is not
going to be custom for each individual, just to new recievers. In
order to do that I need to capture the date the check box is selected
so I can run a query each month of the "newbies". I thought about
creating a table for this, and then using an OnClick event to enter a
new record in the table with the contact id and the date and time
clicked on. However, I also realize, that if I uncheck it so they
don't receive it, I need to be able to remove them from this table, or
add a new record that shows them as not to send.
As a hack, I thought I would ask for advice on the best design to
accomplish this goal.
Thanks in advance for your help!
Mike