tracking sent emails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You might consider adding EmailDate to tblCustomerEmail.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Thanks guys ... very helpful.

Steve said:
You might consider adding EmailDate to tblCustomerEmail.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
Click to expand...
 
Back
Top