AnsweredAssumed Answered

Print and send mail for each customer

Question asked by techccaq on Oct 14, 2009
Latest reply on Oct 29, 2009 by TSGal


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.