If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Contacts and New Mailings
I'm trying to determine the best way to design a basic database to track
contacts who receive periodic mailings from us. I have created a Contacts table (ContactID, Contact), a Mailing table (MailingID, Description) and a MailingDetails table (ContactID, MailingID). Once the Marketing Dept. decides to send out a new mailing, my goal is to create a form where users can enter the name of the new mailing, plus quickly check off which contacts will be receiving it. Any suggestions on a way to approach that would be appreciated! -- Steve C |
#2
|
|||
|
|||
Contacts and New Mailings
On Feb 23, 12:05*pm, Steve C wrote:
I'm trying to determine the best way to design a basic database to track contacts who receive periodic mailings from us. *I have created a Contacts table (ContactID, Contact), a Mailing table (MailingID, Description) and a MailingDetails table (ContactID, MailingID). Once the Marketing Dept. decides to send out a new mailing, my goal is to create a form where users can enter the name of the new mailing, plus quickly check off which contacts will be receiving it. *Any suggestions on a way to approach that would be appreciated! -- Steve C The answer depends somewhat on the number of recipients you would be sending to. If it's a manageable number, you could use a multi-select listbox to choose which people to send the message to and then just add them to the address list in code. |
#3
|
|||
|
|||
Contacts and New Mailings
Another way that I use for larger numbers of recipients: add a yes/no field,
e.g. SendMail, to the Contacts table. Each time a new mailing is created, update SendMail to FALSE for all contacts. Display all contacts in a continuous or datasheet form, where SendMail is displayed as a checkbox, and have users click on this field for each desired recipient. Base your mail-merge on a query that selects from the Contacts table where SendMail=TRUE -TedMi "Piet Linden" wrote in message ... On Feb 23, 12:05 pm, Steve C wrote: I'm trying to determine the best way to design a basic database to track contacts who receive periodic mailings from us. I have created a Contacts table (ContactID, Contact), a Mailing table (MailingID, Description) and a MailingDetails table (ContactID, MailingID). Once the Marketing Dept. decides to send out a new mailing, my goal is to create a form where users can enter the name of the new mailing, plus quickly check off which contacts will be receiving it. Any suggestions on a way to approach that would be appreciated! -- Steve C The answer depends somewhat on the number of recipients you would be sending to. If it's a manageable number, you could use a multi-select listbox to choose which people to send the message to and then just add them to the address list in code. |
Thread Tools | |
Display Modes | |
|
|