Making Access complete the To: in outlook

[tlampher]

I am building a customer database and have access running a form where I can narrow the customers down by the system they use and what part of the country they are located. I have the output of the form making a report. I want my button on the report page to send an email to all customers in the report. is this possible? I am using the sendobject command and that only allows me to send the report as an object in the email. Is it possible to even do what i need to in Access?

[Microsoft Access Database]

Yes you can do that. Set a reference to the Outlook object model within Access. You would be best to use a query which Access can then loop through to fetch the To names. It requires some Outlook programming within MS Access, but it is only a few lines at best.