Print and send mail for each customer
I have two tables. One called "customers" and the other is "customers related". We create a relationship with "ID_customers" on both table.
The "customers" tables is connected by "ID_Customers" on table called Order_lines.
I create another "order_lines_for Customers_related" based on "Order Lines"(Occurrences).
The "customers_related" table is connected by "ID_Customers_related" on table called "Order_lines_for_customers_related". So, whatever I enter some lines in my order, I could have the other for my "customers" and my "customers related".
So, I created a report from table "order_lines_for Customers_related".
I have a Header containing the information for my customers.
I have a sub-summary(Leading) sort by the first and last name of the "customers". I select Page break before each occurence and restart pages numbers after each occurences.
I have the body containing the name of the person that order some activities and also the cost for all the activities.
I also have another sub summary (Trailing) sort by first and last name of the "customers". This part contains informations about payment other information base on summary for billing.
I finally have a footer containing the page number ( Page ##).
I have 25 customers. I expected to have 50 pages in my report.
I just want to print a PDF file for each 25 customers ( 1 file by customer) and send it by mail to the right customer.
I suppose that it could be done but how ?
Do I need a loop in my script ?
If I click on the preview mode, I could see all the pages and the information that I want but if i click on save as PDF, it print all my 50 pages.