Paul Wagstaff wrote:[color=blue]
> 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...[/color]
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.
