2000-2003 Merge Problem

[Mary Fetsch]

I have a user who just upgraded from Word 2000 to Word 2003. She has a merge
file that uses a query from an Access 2000 database as the data source. The
data source comes into Word correctly, and she can do her merge. She has a
problem, though, when she only wants to merge certain records (e.g., only a
certain city). I

t appears that she now has to open the mail merge recipients screen and use
the City down arrow to choose the city she wants. The problem occurs when
she opens that screen. Her data source has 919 records, and it seems to hang
on record 666. She waited 25 minutes for all records to appear on the
screen, but after that, she stopped Word. This has happened more than once.
Any ideas?

 

[Doug Robbins - Word MVP]

I would initiate the merge from Access by opening the table or query, right
clicking on the city field and applying a filter and then from the Tools
menu, select Office Links and then Merge it with Microsoft Word.

--
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

 

[Mary Fetsch]

Thanks for your response. Initiating from Access isn't really an option
because the user doesn't know Access at all. I created a new document that's
just like the old document, but now the data source can be filtered from
Word. I guess the old document was corrupt somewhere.

 

[macropod]

Hi Mary,

You could use a SKIPF field in your mailmerge main document to skip all records for which the city name in the City mergefield isn't
the one you want. For example:
{SKIPIF«City»<> "London"}
where the field bracer (ie '{}') are created via Ctrl-F9 and the chevrons represent the mergefield delimiters.

 

[Mary Fetsch]

Thanks for your response. Your suggestion isn't really an option because the
user doesn't know how to use merge fields. Using the Word document is the
easiest way for the user to use filters, and now that I created a new
document just like the old document, things seem to be working well.

Hi Mary,

You could use a SKIPF field in your mailmerge main document to skip all records for which the city name in the City mergefield isn't
the one you want. For example:
{SKIPIF«City»<> "London"}
where the field bracer (ie '{}') are created via Ctrl-F9 and the chevrons represent the mergefield delimiters.

--
Cheers
macropod
[MVP - Microsoft Word]

I have a user who just upgraded from Word 2000 to Word 2003. She has a merge
file that uses a query from an Access 2000 database as the data source. The
data source comes into Word correctly, and she can do her merge. She has a
problem, though, when she only wants to merge certain records (e.g., only a
certain city). I

t appears that she now has to open the mail merge recipients screen and use
the City down arrow to choose the city she wants. The problem occurs when
she opens that screen. Her data source has 919 records, and it seems to hang
on record 666. She waited 25 minutes for all records to appear on the
screen, but after that, she stopped Word. This has happened more than once.
Any ideas?