Jump to content
Sign in to follow this  
Fred Rogers

Printing a list of records on to a form letter

Recommended Posts

Fred Rogers    0

Ok, I am new to FileMaker so please ask any questions if I leave out an important detail.

What I am trying to do is print a letter that has a variable amount of information in it. 

I have a table with clients and a related table with invoices in it. 

What I would like is a letter that has some client information at the top, ie our logo, the date, and the client's mailing address, then a little message about the invoices. Then I would like it to print all the out standing invoices number, date, and description. (all fields in the invoice table) and end with a nice statement with the total number of outstanding invoices and please pay etc. 

I tried making a list layout using the invoice table with all the client info in the header, then the information I wanted in the body, then closing statement in the footer. 

Something like:

Header: Logo, <<client::address>>, dear <<client::fullname>>

Body: Invoice numb:<<Invoice num>>  On <<Date>> work done: <<Description>>

Footer: Nice message with a total and please pay etc

When I run the script to go to related records, do my find and sort by script it looks ok. All the invoices are listed.

But when I print the layout it breaks each invoice record in to a new page. ie


Invoice 1



Invoice 2



How Can I get a print out like looks like:


Invoice 1

Invoice 2


I am so close on getting the letter done. I have the scripts selecting the correct invoices. Now I need to get all the invoices printing in the middle of the header and footer and I will be good. 



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.