Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    mail merge data source (word 2003)

    I have a merge document that has a database query as its data source. The database is shared from a network drive by 7 users with the document residing on there workstation. 6 users open the document and the database opens with it. One does not. The one that does not had a recent computer upgrade. The software was just reloaded. When this issue arose Office was upgraded to 2003 (all others are still on 2000) but the problem continued. The database was created in Access 2000.

    When the document on this machine is opened it is clearly a merge document, that is, the merge fields are visible and the toggle icon displays data from the data source. When the document is merged the option is given to either merge all the data or just the current data. Whichever choice is made a merge takes place, however the data source is a query and usually give the option to select the ID for the particular data you want to merge. This option is not available so the desired data cannot be selected.

    This is a new one on me.
    Thanks
    chuck

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

    Re: mail merge data source (word 2003)

    Mail Merge was seriously overhauled in Word 2002 (XP), the default method for connecting to the data source is different in Word 2002 and later than it was in Word 2000 and before.

    Let the Word 2003 user try the following in Word:
    - Select Tools | Options...
    - Activate the General tab.
    - Tick the check box "Confirm conversion at Open".
    - Click OK.
    - Open the merge document.
    - Activate the mail merge wizard (task pane).
    - Go to step 3 and click Select a different list.
    - Browse to the Access database and click Open.
    - You'll be asked to select a method for connecting to the database.
    - Select MS Access Databases via DDE (*.mdb, *.mde) and click OK.
    - Proceed as usual. The query should now prompt for the parameter.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mail merge data source (word 2003)

    I followed your steps and made the connection but it will not keep it. After I open and link to the datasource it immediately asks for the datasource again though the datasource remains open. I think the issue is beyond the Office apps and is something in the network.
    Thanks
    chuck

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

    Re: mail merge data source (word 2003)

    I hope your IT department will be able to solve it.

Posting Permissions

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