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
|
|||
|
|||
How do I put multiple email addresses in one contact?
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. |
#2
|
|||
|
|||
On Fri, 05 Nov 2004 02:12:02 -0800, Nic1985 wrote:
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. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to send multiple files to an email contact | David | Worksheet Functions | 2 | September 22nd, 2004 09:49 PM |
Outlook and multiple email addresses | Long Nguyen | General Discussion | 1 | September 12th, 2004 02:40 AM |
Wrong From E-Mail Address When Sending Faxes From Outlook | Marc Bressman | Fax | 3 | August 13th, 2004 07:14 AM |
supporting multiple email addresses per contact | shane | Contacts | 1 | June 16th, 2004 05:57 PM |
Auto Insertion contact name, company, tel, fax & email from Outlook | Michael | Mailmerge | 1 | June 11th, 2004 01:08 PM |