Merge Multiple Records per page

[Access101]

In the Main Merge doc I have:
<<fname>>
<<fname>>

In the Data doc I have column heading and two names
fname
Bill
Mike

When I merge, Bill, of course, replaces each <<fname>> with Bill and looks
like this:
Bill
Bill
What I want, is this:
Bill
Mike

Is this possible?

Any help is appreciated.

 

[Doug Robbins - Word MVP]

It is possible by either using a Directory type mailmerge main document in
which you would only have

<<fname>>

When you execute such a mailmerge to a new document, then you will get

Bill
Mike
etc. for all of the records in the data source

Alternatively, you would need to put a <<Next Record>> before the second
mergefield

<<fname>>
<<Next Record>><<fname>>

But that only works for two records and if you have more than two records,
the next two will appear on the next page.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP