How do I put multiple email addresses in one contact?

[Nic1985]

I often need to send the same email to multiple clients and would like to
know whether I could store all of their email addresses within one contact to
make it quicker and easier. I would like to just be able to click on the
general contact named "clients" and for the email to go to all the email
addresses (100 +) within that contact.

 

[Rick Brandt]

I often need to send the same email to multiple clients and would like to
know whether I could store all of their email addresses within one contact to
make it quicker and easier. I would like to just be able to click on the
general contact named "clients" and for the email to go to all the email
addresses (100 +) within that contact.

You clearly have a one-to-many relationship between clients and email
addresses. This indicates two tables (Clients) and (EmailAddresses) be
created having a one to many relationship on the ClientID field. Then you
can have as many or as few Email entries per client without any further
impact on your design.

Data entry for such a relationshp would typically be done with a
form/subform configuration. For the email message you would create a
RecordSet against the EMailAddresses table with a WHERE clause that limits
the rows to the desired client and then loop through the RecordSet to
retrieve each address. You could then send each message individually as
you are looping or you could have the loop build up a single string
variable containing all of the addresses delimited with the appropriate
separator and send one message at the end of the loop.

There are various examples of the above to be found with a Google search.