Re: MailMerge Word 2003 to Access 2000 query blank data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Doug Robbins (dkr_at_NOmvpsSPAM.org)
Date: 01/15/05


Date: Fri, 14 Jan 2005 19:31:17 -0500

Try using one of the different connection methods that will become available
to you after selecting Options from the Tools menu and on the General tab,
checking the box for the item "Confirm conversions at open."

-- 
Please respond to the Newsgroup for the benefit of others who may be 
interested.   Questions sent directly to me will only be answered on a paid 
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
"BCool" <BCool@discussions.microsoft.com> wrote in message 
news:FA614ADC-5098-485C-B17E-29893D0273CD@microsoft.com...
> While in Word 2003 MailMerge the data that I need is in a Access 2000 
> query.
> When I connect to the database the table name and queries are in the same
> box.  If you select a query and run the MailMerge process you can see the
> headers however you cannot see any data records.  Please help this a 
> massive
> database and informtion must be pulled at a minutes notice. 


Relevant Pages

  • Re: Cant Open Data Source (Query) where criteria is defined by fu
    ... TWO additional instances of the database are being opened during the ... > mailmerge process. ... that data source when it opens the document, ... construct a query that relies on selecting flagged/unflagged records. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)