tracking sent emails

S

S Willingham

This might be a rookie question but I am having a hard time wrapping my mind
around this. What is the best strategy for tracking sent emails to contacts
from my database.

I have a customer database and I email product updates. I need to know who
has been sent specfic emails.

Is the best way to add a column with the email name and enter yes if they
were sent that email.

Thanks in advance for any input.

Steve
 
R

Rich K

I would probably create a table that contains the email information, like

tblEmailInformation
----------------------
EmailID
EmailName
(and whatever other fields you need to specify email)

Then I would create another table that links the customers with the emails

tblCustomerEmail
--------------------
CustomerEmailID
EmailFK
CustomerFK

Hope this helps.
 
Top