Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Leamington Spa, Warwickshire, England
    Thanked 0 Times in 0 Posts

    Using Access as a data source (XP 2002)

    I tried to use the data from a select query to merge in Word. First it doesn't give me the option to choose a query to do a merge. I just get an error. I have tried it from Access (merge with word) and from Word and neither way will work. The select query is based on two tables one for objectors and one for agents. An Objector may use an agent and all correspondence should be sent to the agent. This means that the address can come frrom the objectors table unless the agent used field is selected.

    I thought it would be easy to do and I could have sworn you got the option to use a query as part of a mail merge in past versions of Word/ Access.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Using Access as a data source (XP 2002)

    Also asked in <post#=342060>post 342060</post#> in the Access forum. Although it is mostly a Word problem, discussion has already started in the other thread, so I will lock this one to avoid duplication and confusion. If you want to reply, please do so in the other thread. Thank you <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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