Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Morecambe England, Lancashire, England
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mailmerge (Office XP)

    When I say I know all about Mail merge in office 2000 - obviously I don't!

    However I do know enough to be able easily create a mail merge document go get the data source from an Access database. Usually I will have written a query that has say in a town field, a criteria that says [Enter the town name] and then it just lists all that town from the database.

    If you are in Office 2000 you can pick from the Access database either a table or a query and of course it

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

    Re: Mailmerge (Office XP)

    Although the way Word handles mail merges has changed, you should still be able to specify a query as data source. Make sure that you have Confirm Conversions checked in the General tab of Tools | Options...
    When you select an Access database (.mdb) in the third step of the new Mail Merge Task Pane, specify that you want to link MS Access Database via DDE. An instance of Access will start, and you'll see a dialog with tabs for tables and queries.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Morecambe England, Lancashire, England
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mailmerge (Office XP)

    Dear Hans - Many thanks for your help - I much apprciate it - Michael

Posting Permissions

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