View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merge problem with Access DB

You need to re-attach the data source to get the option of how the
connection should be made.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Doug,
No questions were asked after I checked the "Confirm Conversion at Open"
box. Word went straight into my merge document w/o giving me the option
to
choose a method.
--



"Doug Robbins - Word MVP" wrote:

In Word, from the Tools menu, select Options and then go to the General
tab
and check the box against the "Confirm conversions at open" item. After
doing that, when you attach the data source to the mail merge main
document,
you will be asked for the method by which the attachment should be made.
Try the various options. Probably the DDE one will allow you to do what
you
want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Using MS Access Query as my data source, I only can merge data w/o
putting
any criteria in the query. Once I ask the query to retrieve a
particular
data, the query will retrieve it, but Word will not populate the data.
I
do
not want the client to have to use the "Mail Merge Recipients" to
select a
group of clients. After the query retrieves the group selected, I want
to
merge the data by simply clicking the "View Merge Data" button. I can
do
this already w/o any criteria in the query, but I will end up with the
whole
DB being populated in Word.

Thanks in advance for your help.