So far, so good with my mail merge, thanks to the helpful people here!
Last question.
My Access table has 2 rows. On the first page of my merge, I need it to show 'owner1' and 'owner2' which are contained in separate lines, but I can do that with the {next} function. But then I need it to show whichever address where the state matches another field.
Even more complicated, when it comes to the bottom, I need 1 page with Owner1 name on the signature line and a repeated page where Owner2 name is on the signature line. (I can make this work with the {next} function also.
I can make each piece work independently, but if I use the {next} function to change the names on the first page, I don't get 2 pages at the bottom, because the bottom is using the {next} function also. Is there something similar to {previous} or a way to tell it to return to the top of the table?
Last question.
My Access table has 2 rows. On the first page of my merge, I need it to show 'owner1' and 'owner2' which are contained in separate lines, but I can do that with the {next} function. But then I need it to show whichever address where the state matches another field.
Even more complicated, when it comes to the bottom, I need 1 page with Owner1 name on the signature line and a repeated page where Owner2 name is on the signature line. (I can make this work with the {next} function also.
I can make each piece work independently, but if I use the {next} function to change the names on the first page, I don't get 2 pages at the bottom, because the bottom is using the {next} function also. Is there something similar to {previous} or a way to tell it to return to the top of the table?