Mail Merge from Access Limits & Workarounds

[Paul Wagstaff]

Hi folks,

Please forgive me - this straddles Access & Word '97
If I could, I'd send a (approx 1000 records) recordset to Word, mailmerge
it & save the new document.

However, Word's mailmerge process stops at around 400 records (I've only
sent it a handful of fields for testing). My current method involves a saved
..doc with its datasource saved as my Access query. Thro' Access VBA I:

open the .doc, then,
mailmerge.Execute
Save my new doc
close the docs

stare expectantly at my monitor, then despair at my incomplete (though
saved) document.

Can anyone help me with (a) a better way to programatically merge a
recordset into Word or (b) give me some feedback on whether I'm asking too
much from Word(?)

I'm thinking of restricting my query to the Top 200 records & using a '>
intID' paramter in the query itself. After finding the TOTAL number of
records, I can divide thisd number by say, 200, & then determine how many
times I need to run the query. If I grab the ID (autonumber) after each call
to the query and pass this value to intID, I should be able to get the next
200 records and so on...

Is this a sensible approach?

All suggestions are welcome.

Paul.

[Darryl Kerkeslager]

Paul Wagstaff wrote:

Hi folks,

Please forgive me - this straddles Access & Word '97
If I could, I'd send a (approx 1000 records) recordset to Word, mailmerge
it & save the new document.

However, Word's mailmerge process stops at around 400 records (I've only
sent it a handful of fields for testing). My current method involves a saved
.doc with its datasource saved as my Access query. Thro' Access VBA I:

open the .doc, then,
mailmerge.Execute
Save my new doc
close the docs

stare expectantly at my monitor, then despair at my incomplete (though
saved) document.

Can anyone help me with (a) a better way to programatically merge a
recordset into Word or (b) give me some feedback on whether I'm asking too
much from Word(?)

I'm thinking of restricting my query to the Top 200 records & using a '>
intID' paramter in the query itself. After finding the TOTAL number of
records, I can divide thisd number by say, 200, & then determine how many
times I need to run the query. If I grab the ID (autonumber) after each call
to the query and pass this value to intID, I should be able to get the next
200 records and so on...

I'm not aware of any mail merge limit, but I'm far from an expert in the
field. Fortunately, I can refer you to Albert D Kallal's website, 'cuz
he is. Having used a portion of what he has, I do believe you'll like
the results.

http://www.members.shaw.ca/AlbertKal...rge/page2.html
Darryl Kerkeslager
Power corrupts.
Absolute power corrupts absolutely.
Knowledge is power.