Data Source

[W. Guy Delaney]

I have a query in Access for information I want to use in a mail merge in
Microsoft Word. The querry runs perfectly in Microsoft Access.

When I go to Microsoft Word and begin designing the mail merge, when browse
to my database, choose and loo for my querry is otther. Other querries show
up, but not the one I need.

How can I see all querries?

 

[Arvin Meyer [MVP]]

Why not run from Access?

For a single record merge directly from a form, this is a great method:

http://www.datastrat.com/Code/WordMerge.txt

For a full merge, you might try Albert D. Kallal's code:

http://www.members.shaw.ca/AlbertKallal/msaccess/WordMerge2008.zip

 

[W. Guy Delaney]

I'd rather not do it this way. I'm very familiar with the Microsoft mail
merge, and after looking at the code you sent, I'd really like to stay with
Word. Later when I have more time, I might try your suggestion, but hope you
can help me find lthe data source from Microsoft Word.

 

[Gina Whipp]

W. Guy Delaney,

If I remember right, only select queries that can be used by Word will show.
What type of query is it?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Arvin Meyer [MVP]]

I think that you do need an editable query to see it from Word. The only
other thing I can think of then is to try renaming your query. If that
doesn't work, perhaps asking in a Word newsgroup, might be able to help.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com