Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge - Changing Access Data Source

    Last year I created a merge document in Word (97 SR2), memo2001.doc, that used a query in an Access database (97 SR2) named data2001.mdb.

    For this year's memo, I copied memo2001.doc into memo2002.doc, making necessary text corrections.

    Can I easily change the data source of memo2002.doc to look at data2002.mdb rather than data2001.mdb? The only method I can see is to (a) convert the merge document back to a normal document and then ([img]/forums/images/smilies/cool.gif[/img] recreate the merge document with the new data source. Any other answers?

    I couldn't find the solution in Word's help file.

  2. #2
    New Lounger
    Join Date
    Nov 2001
    Location
    Virginia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge - Changing Access Data Source

    In the Mail Merge dialog box the 2nd option, Get Data drop down list, select Open Data Source (Not Create Data Source) and pick data2002.

Posting Permissions

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