Mail Merge specific records

[Diane]

Group,
I have a mail merge document that works fine, but a user is requesting that
I change the order of the completed merge. Example, a mail merge
sequentially merges "NEXT" record, is it possible to merge the 10th record,
and then count 10 more down in the file, and merge it. I really don't think
this is possible with a mail merge, it seems that I would have to change this
document to use VBA code to accomplish this task.

Any thoughts would be appreciated!

 

[Peter Jamieson]

It depends on what they mean exactly. If they want records 1,11,21 etc. then
you could add nine { NEXT } fields to the end of your mail merge main
document. Or there may be some way (which would depend on what is in the
data source) to do it, but setting up anything other than simple filters
would also require yo to use VBA, or to do something in the data source such
as create a Query (in Access) etc.

 

[macropod]

Hi Diane,

To merge every 10th record, you could use a SKIPIF field coded like:
{SKIPIF {=MOD({MERGESEQ},10)}> 0}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.