hi

at this moment i can make a report.
and every customer get one report (this report need to be send to this customer as a html email)

but if i do it i have to open every customer click on report and then send it ..

maybe there is a better way?

here the sample database..


gr.

In code, you can create a recordset from your customers table and loop through it and send each customer an email with code.

"end each customer an email with code."

what do you mean.. i need to write html code ????

isn't there a way to send the report?
i have the report how it need to be..

gr.

If you want to automate sending emails from the values in a table you will need VBA code.