Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
RB
 
Posts: n/a
Default Query from access does not show up in list for mail merge

Trying to perform mail merge in word. When I select my database source
(access), the query I want to use is not listed as an option to choose from.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Query from access does not show up in list for mail merge

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the datasource, you will be presented with a dialog box in which
you can select the way in which the connection to the data source is made.
Selecting the DDE option may overcome your problem.

--
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

"RB" wrote in message
...
Trying to perform mail merge in word. When I select my database source
(access), the query I want to use is not listed as an option to choose
from.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TedMi
 
Posts: n/a
Default Query from access does not show up in list for mail merge

The query will not show up if it is hidden. You must unhide it in Access
before you set it up as the datasource in Word. Once set up, you can then
hide it again and it will work.
--
Ted

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge Query - Works in Access; fails in Word Gary Stark Mailmerge 4 October 6th 05 07:57 PM
How to use access query computed fields in Word mailmerge Rey Mailmerge 5 June 23rd 05 06:26 PM
Mail Merge - Parameter prompts twice... TL Mailmerge 6 June 17th 05 02:58 PM
Merge Access OLE Photo to Word Andy Mailmerge 2 June 8th 05 12:48 PM
Word 2003 and Access 2003 Mail Merge question HD87glide Microsoft Word Help 2 December 15th 04 02:29 PM


All times are GMT +1. The time now is 06:59 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"