If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2000-2003 Merge Problem
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? |
#2
|
|||
|
|||
2000-2003 Merge Problem
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" wrote in message ... 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? |
#3
|
|||
|
|||
2000-2003 Merge Problem
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. "Doug Robbins - Word MVP" wrote: 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" wrote in message ... 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? |
#4
|
|||
|
|||
2000-2003 Merge Problem
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] "Mary Fetsch" wrote in message ... 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? |
#5
|
|||
|
|||
2000-2003 Merge Problem
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. "macropod" wrote: 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] "Mary Fetsch" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|