I am using Word's AutoNew macro to draw info from an Access database
to merge contracts containing Access main records and sub-records.
I need to know the number of sub-records in my merge before I start
the merge.
I have tried ActiveDocument.MailMerge.Datasource.RecordCount with no
luck - it gives me the number of records in my entire data table, not
the number I have selected for this merge.
I realize that there are probably much easier ways to approach this,
but I'm locked into this method (Word merge) and am not looking to re-
design the process.
Any help would be appreciated,
Doug Banwell
Doug Robbins - Word MVP - 26 Oct 2007 05:20 GMT
Anzwered in the mailmerge.fields newsgroup.

Signature
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
>I am using Word's AutoNew macro to draw info from an Access database
> to merge contracts containing Access main records and sub-records.
[quoted text clipped - 10 lines]
> Any help would be appreciated,
> Doug Banwell