Word merge problem still

[Guest]

Hi,

I posted this before, but I still have the problem.

I'm trying to do a mail merge from a query in access. I
select the query, click on Tools, select Office Links and
select "Merge it with MS Word", and go from there. I
already have my word document. When in Word and I click
on "Merge" it counts the records being merged (3854) and then the line that
shows the merge count changes to "sec 1 1/xxxx" where xxxx starts counting
all over again and gets slower and slower. What is going on????? My table
has
3854 records and my query has only 154 records.
When the merge stops I have 3854 pages.

What am I missing or am I confused about how the works?

Thanks,
Phil

 

[John Nurick]

Hi Phil,

What versions of Windows, Word and Access are you using? Have you
installed the most recent service packs?

Also, please explain a bit more about what's happening. You've told us
that the query returns 154 records and that the merged document has 3854
pages, but not what data the query returns, what's in the "master"
document, what kind of merge you're having Word do, what you expect the
merged document to contain, and what it actually contains.

In particular, how many sections (Word sections) are there in the merged
document? A normal ("letter") merge produces a merged document
containing one section for each record in the data source, with as many
pages in each section as are generated by the interaction of the
contents of the "master" document and the data in the corresponding
record.

 

[Guest]

Hi John,

I finally got it to work. I thought that when you picked a query that the
selection criteria came with it. When I click on "Merge" and the merge
window comes up, if I enter the merge criteria I get the results I wanted.
The only problem is that I need to remember the query criteria.

Thanks,
Phil

 

[John Nurick]

Phil,

You may like to check out Albert Kallal's sample mailmerge application:
http://www.attcanada.net/~kallal.msn/wordmerge/index.html