5 Replies Latest reply on Feb 27, 2009 12:50 PM by mwc_1

    Emailing a specific layout?

    goodlife

      Title

      Emailing a specific layout?

      Post

      I am on a Mac using Filemaker 9 Pro. I have a layout that includes text and fields. I would like to email the contents of the layout to each individual record. This is for invoicing for membership. The layout includes each members info for updating. How do I send something that would look like the printed page to an individual member. And can I do this for a found set so each member gets only one invoice with their info on it?

       

        • 1. Re: Emailing a specific layout?
          mwc_1
             Look at this thread for some inspiration... Emailing out schedules to individual people - help!
          • 2. Re: Emailing a specific layout?
            goodlife
               I'm afraid I don't know enough about scripts to know how to adapt this to my needs. Do I have to generate a pfd to do this or can FileMaker create a text email from the layout text and field text?
            • 3. Re: Emailing a specific layout?
              mwc_1
                

              If you want to create a formatted email (Looking like your layout) then a PDF of the layout is needed.

              You can create an text email with fields, but you cannot format the data like your printouts.

               

              For a manual process, goto File--> Save/send records as PDF, then use the attach PDF to email option.

              • 4. Re: Emailing a specific layout?
                goodlife
                   Thank you. Can I automate this with a script so that if I have 50 records in my found group, it will make 50 pdfs and email each record to the individual it's supposed to go to? I have an email field.
                • 5. Re: Emailing a specific layout?
                  mwc_1
                    

                  Reduced instruction from the script I referenced from ORLANDO :

                  This is the jist...but I haven't tried it....

                   

                  Do your find, then make a script to execute the following--->

                   

                  Set Error Capture [ On ]

                  Go to Record/Request/Page [ First ]

                  Loop

                      Set Variable [ $ActiveEmail ; YourTable::Email ]  

                      Go to Layout [ YourLayout ]

                      Set Variable [$FilePath ; "filemac:" & Get ( TemporaryPath ) &  "Report.pdf"]

                        Save Record as PDF [ No dialog ; "$FilePath" , Current record ]

                        # PDF has been created, now attach and send in email

                        Send Mail [ To:$ActiveEmail ; subject: "Report" ; "$FilePath" ] 

                      Go to Layout [ YourLayout ]

                      Go to Record/Request/Page [ Next ; Exit after last ]

                    End Loop

                    #

                   

                   

                  When you get this working...you may want to add a scripted FIND to the process.