Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Leamington Spa, Warwickshire, England
    Posts
    136
    Thanks
    0
    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
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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
  •