2 Replies Latest reply on Feb 24, 2010 11:53 AM by mmccarty

    needing to add extra addresses in sending documents



      needing to add extra addresses in sending documents




      I have Filemaker 10 Advanced and need to have varying amounts of addresses that are put in the letter.  We have to cc a people and it might be 2 - 6 companies and I have to have them in the top of the doument and am wondering how to insert them in there without having blank space if there is only one or two.


      ABC company


      City, State Zip


      DEF Company


      City, State Zip


      and may go up to 

      XYZ Company


      City, State Zip


      Appreciate any help on this.


        • 1. Re: needing to add extra addresses in sending documents

          Printed, PDF or Email?


          Assuming Printed or PDF for this response...


          1. You could display the addresses in a 6 row portal set to slide up. You have limitations with this approach and if you ever get more than 6 addresses, the 7th address won't show.
          2. If your addresses are stored in a related table as they should be, base a layout on this table of addresses. Put the addresses in the body and put the document text in a Trailing Grand Summary part. You might want a Join table to link addresses to your document text. If so, make your join table the referenced table in layout setup and add the document and address fields from related tables.



          • 2. Re: needing to add extra addresses in sending documents

            Use sliding/printing to remove unwanted spaces.  This feature shrinks your field to fit the data.

            In layout mode, right click on your address field and choose Set Sliding/Printing.

            Check "Sliding up based on" and choose how you want the field to slide.  You probably also want to check "Also reduce the size of the enclosing part" this will slide up the whole layout part (aka body, subsummary) along with your field.


            You won't see any difference in Browse mode but the sliding will take affect when you enter preview mode and when you export your letter.