Oct 20 2011, 11:30 AM
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..
Oct 21 2011, 01:35 PM
In code, you can create a recordset from your customers table and loop through it and send each customer an email with code.
Oct 21 2011, 01:55 PM
"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..
Oct 21 2011, 02:48 PM
If you want to automate sending emails from the values in a table you will need VBA code.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here