Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mail Merge {next}

Status
Not open for further replies.

pluto1415

MIS
Apr 28, 2009
78
US
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?
 
Hi Pluto,

I think you'll find you can acieve what you're after by bookmarking the relevant mergefields and using cross-references to those bookmarks wherever you need the data replicated.

Cheers

[MS MVP - Word]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top