Sending one email to multiple email addresses from a form

  • Thread starter Thread starter Henry
  • Start date Start date
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
 
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)
Click to expand...

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/
 
Back
Top