Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access will not merge. names show, but not when merging with Word
I have got Access 2000 and Word 2003, and when I try to Mail Merge as before,
although the query I want to merge contains 55 names, when I try to merge to any Word 2003 document the query appears to be empty, and no names will appear. I thought the thing was supposed to be straight fiorward. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access will not merge. names show, but not when merging with Word
From a recent response to a similar question:
The chances are that the queries use wildcards, and use the older Jet convention where "*" stands for a number of characters and "?" stands for a single character. Access/Jet can be in one of two modes (see ANSI SQL Qeury mode" in Access Help for more info): Jet mode (as above) and ANSI mode, where the equuivalent wildcard characters are % and _. Unfortuantely, when you get data via the Jet OLEDB provider (which is what Word 2003 does by default), you have to use the ANSI wildcards. if you try to get data from a query that uses the Jet wildcards, nothing is retrieved unless the database has been converted to ANSI Query mode (and since making that change has consequences for everything that works with an Access database, it needs to be thoroughly planned and tested). When you connect to Access data for use as a mail merge data source in Word 2003, you can connect using DDE, which opens Access and uses Access to execute the queries (I think). However, that option is not available, as far as I know, when you get data using a DATABASE field (you can select a DDE option but the resulting field fails). So as far as I know the only workarounds a a. change your database format and all the queries with wildcards b. in Access, duplicate all the queries with wildcards, and modify the duplicates so that they use the ANSI wildcards. Use the original queries when in Access and the duplicates in Word (but of course, if your queries reference other queries, it's a bit more complicated...) Peter Jamieson "Peter Kendrick" Peter wrote in message ... I have got Access 2000 and Word 2003, and when I try to Mail Merge as before, although the query I want to merge contains 55 names, when I try to merge to any Word 2003 document the query appears to be empty, and no names will appear. I thought the thing was supposed to be straight fiorward. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Change paper size; Word changes to invalid margins | New Users | |||
Word 2003 Merge won't show data in Access Query? | Mailmerge | |||
In Word, how can I see all files (*.*) in "save as"? | New Users |