Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Source
Yes, but when you connect using OLEDB or ODBC, you cannot see certain types
of query (e.g. parameter queries, queries that invoke functions defined in Access in VBA ("user-defined Access functions", queries that invoke certain other built-in Access VBA functions (mainly the financial time series ones), some Union queries etc.) Also, queries that use the older "?" and "*" wildcards in "LIKE" expresions will not work with OLEDB. IN most of those cases, you have to connect using DDE In the case of the wildcards, you can switch everything over to the newer syntax (SQL-92) in Access and use "_" instead of "?" and "%" instead of "*". But that's quite a big move in some cases and needs to be thoroughly tested before you commit. Peter Jamieson "LDanix" wrote in message ... Is it possible to use a query in Access as a mail merge source? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge can't find data source in Office XP...but it could in 2000! | Mailmerge | |||
Word 2000 mail merge documents won't save Access 2000 data source | Mailmerge | |||
Mail Merge with separate Source Header document | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Merge Data Source path | Mailmerge |