Sending one email to multiple email addresses from a form

H

Henry

In my large database of clients, i do have up to 5 email addresses for each
department within my clients company. (i.e. sales, marketing,finance)
I need to be able to send one email to all the email addresses so a specific
dept (let's say all the Sales email addresses).

I tried and tried and only able to send one emailor to open the email object
but the email address from the specific colum do not show in the TO field..

Help!!! thank you
 
T

Tony Toews [MVP]

Henry said:
In my large database of clients, i do have up to 5 email addresses for each
department within my clients company. (i.e. sales, marketing,finance)

I'd suggest putting those email addresses in another table with a
foreign key pointing to the department company. I'd also have a
department type table, which is the sales, marketing, finance, etc.

This allows for more than five email addresses and/or multiple email
addresses within one department.

If this is how it is already setup that way then I apologize for
wasting your time. It just sounds like you have five email fields in
your company department table.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top