View Single Post
  #2   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

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.