Results 1 to 2 of 2
2004-02-11, 09:24 #1
- 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.
2004-02-11, 09:57 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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>