Microslf Access 2002 – Sending emails

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