Reply
 
Thread Tools Display Modes
  #1   Report Post  
geordymac
 
Posts: n/a
Default How do I Mail Merge from an Access Query?

I was having the same problem until I found this post. thank you very much.
Why does Microsoft make things like this so difficult??

"ken1975" wrote:

That worked!!!! Thank you, Thank you, Thank you!!!! It has taken 3 days
and 2 MIS people from my company and no one could figure this out!!!!
Thanks again!!

"Doug Robbins" wrote:

From the Tools menu in Word, select Options and on the General tab, check
the box against the "Confirm conversions at open" item and the when you
attach the data source, you will be asked which method of connection to use.
I believe selecting the DDE option will give you access to the queries.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"ken1975" wrote in message
...
I am trying to set up a mail merge in Word to pull from an Access Query.
When I select the Access database as the data source, it only gives me the
tables within that database to choose from. In Word 2000, there was a
tables
tab and a queries tab but in 2003, only the tables are shown. Is there
another process to follow to have it show the queries within the Access
database?




  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

To give us something to dog

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"geordymac" wrote in message
...
I was having the same problem until I found this post. thank you very
much.
Why does Microsoft make things like this so difficult??

"ken1975" wrote:

That worked!!!! Thank you, Thank you, Thank you!!!! It has taken 3
days
and 2 MIS people from my company and no one could figure this out!!!!
Thanks again!!

"Doug Robbins" wrote:

From the Tools menu in Word, select Options and on the General tab,
check
the box against the "Confirm conversions at open" item and the when you
attach the data source, you will be asked which method of connection to
use.
I believe selecting the DDE option will give you access to the queries.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"ken1975" wrote in message
...
I am trying to set up a mail merge in Word to pull from an Access
Query.
When I select the Access database as the data source, it only gives
me the
tables within that database to choose from. In Word 2000, there was
a
tables
tab and a queries tab but in 2003, only the tables are shown. Is
there
another process to follow to have it show the queries within the
Access
database?





  #3   Report Post  
geordymac
 
Posts: n/a
Default

I suppose

"Doug Robbins" wrote:

To give us something to dog

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"geordymac" wrote in message
...
I was having the same problem until I found this post. thank you very
much.
Why does Microsoft make things like this so difficult??

"ken1975" wrote:

That worked!!!! Thank you, Thank you, Thank you!!!! It has taken 3
days
and 2 MIS people from my company and no one could figure this out!!!!
Thanks again!!

"Doug Robbins" wrote:

From the Tools menu in Word, select Options and on the General tab,
check
the box against the "Confirm conversions at open" item and the when you
attach the data source, you will be asked which method of connection to
use.
I believe selecting the DDE option will give you access to the queries.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"ken1975" wrote in message
...
I am trying to set up a mail merge in Word to pull from an Access
Query.
When I select the Access database as the data source, it only gives
me the
tables within that database to choose from. In Word 2000, there was
a
tables
tab and a queries tab but in 2003, only the tables are shown. Is
there
another process to follow to have it show the queries within the
Access
database?






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
why word 2000 mail merge opens multiple instances of access table. Johnny C. Mailmerge 0 February 3rd 05 05:11 PM
Web-Site-based Word Mail Merge & Access DB Alex Maghen Mailmerge 3 January 17th 05 09:52 PM
mail merge and access query DaveAS Mailmerge 6 January 6th 05 06:33 PM
Word 2003 and Access 2003 Mail Merge question HD87glide Microsoft Word Help 2 December 15th 04 02:29 PM
Word mail merge with Access Linda Mailmerge 1 December 7th 04 11:46 PM


All times are GMT +1. The time now is 10:25 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"