Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge (Access/Word03)

    I have a mail merge with data stored in an Access database. Data is in table called tblBuildings and on the qryBuildings. There are two other tables with related queries. Then I combine things with a qryMailMerge. I have added to the tblBuildings and qryBuildings a field called Parking it is also then added to the qryMailMerge. When I use the insert field in Word the Parking field does not show up. Is there a limit to the number of fields on the query that will be displayed in the Insert dialog box? I did remove a couple of fields that aren't used yet that didn't work. I have opened and closed both the database and the Word document several times. I have also reattached, several times, to the qryMailMerge from Word.

    Any thoughts or words of advised would be appreciated.

    Fay

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail merge (Access/Word03)

    Try the following in Word:
    - Select Tools | Options...
    - Activate the General tab.
    - Tick the check box "Confirm conversion at Open".
    - Click OK.

    Now reconnect to the data source. You'll be asked how you want to connect to the data source (OLE DB, DDE, ODBC). Experiment with the available options to see if one does what you want.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge (Access/Word03)

    Thanks Hans. I think I know how I messed it up. Have to wait until I get back to work. Fay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •