Merging to Word

[silenceseeker2003]

In the following tutorial:

http://www.teachers.ash.org.au/jfuller/access/queries/merge1.htm

I learned how to merge an Access table to a Word document.

However, what I noticed was that one can merge only a single table and
only one item per page.

I am actually looking for a way to merge *two* tables (connected by a
third table that simply provides relationship between records in the
first table to records in the second table) - and I would like to have
multiple records per page, not one per page as the above tutorial
shows.

Is there a way to accomplish that?

Ideally I would like to be able to "merge" the *results of an SQL
query* into a Word document (multiple records/sets per page). Is this
possible with MS Access 2002?

Is there a good online source where I can learn how to use MS Access
(2002) in a way less trivial and rigid than the various wizards that
come with Access?

Thanks!
Sam

 

[Douglas J Steele]

You should be able to create a query that joins the tables however you need
to, and use that query rather than a table.

 

[silenceseeker2003]

You should be able to create a query that joins the tables however you need
to, and use that query rather than a table.

Doug, thanks for your answer. Could you please point me to some online
source that shows how to do that?

Thanks,
Sam

 

[Douglas J. Steele]

Using a query should be no different than using a table.

Or are you asking how to create your query?

 

[silenceseeker2003]

Using a query should be no different than using a table.

Or are you asking how to create your query?

No, I know how to create a query. My problem is with the strict tabular
format provided by the "Publish to MS Word" function. Is this the only
format supported? If not, how do I change it?

I would like to be able to create multiple entries (query results) per
page in a format that I carefully craft using MS-Word. I was trying to
find a good tutorial on how to this, but so far I have failed. The
Wizards in Access are very friendly but very rigid (limited).

Can you recommend a good tutorial on how design a word document in
which fields in the document correlate correctly with fields the
results of an Access query?

Thanks,
Sam

 

[Douglas J. Steele]

No, I know how to create a query. My problem is with the strict tabular
format provided by the "Publish to MS Word" function. Is this the only
format supported? If not, how do I change it?

I would like to be able to create multiple entries (query results) per
page in a format that I carefully craft using MS-Word. I was trying to
find a good tutorial on how to this, but so far I have failed. The
Wizards in Access are very friendly but very rigid (limited).

Can you recommend a good tutorial on how design a word document in
which fields in the document correlate correctly with fields the
results of an Access query?

I was suggesting that you have one query which returns all of the data you
require, not that you have multiple queries. I don't believe it's possible
to use anything other than a single data source for a merge in Word.

Realistically, this is a Word issue, not an Access issue. You'll find lots
of good information about mail merges in Word at the Word MVP website,
specifically at http://word.mvps.org/FAQs/MailMerge/index.htm

 

[silenceseeker2003]

I was suggesting that you have one query which returns all of the data you
require, not that you have multiple queries. I don't believe it's possible
to use anything other than a single data source for a merge in Word.

Oops... I am sorry, I didn't explain myself well enough. I meant a
*single* query returning multiple entries. That is exactly how the
"Publish to MS Word" works and that is working excellent - if all I am
interested in is a *table* with all the results.

However, I am interested in a different format, something that I design
myself (similar to an address book or a collection of labels).

Realistically, this is a Word issue, not an Access issue. You'll find lots
of good information about mail merges in Word at the Word MVP website,
specifically at http://word.mvps.org/FAQs/MailMerge/index.htm

I believe you are right. Thanks for the link. I will check it out.

Thanks,
Sam

 

[silenceseeker2003]

I believe you are right. Thanks for the link. I will check it out.

OK. I just tried what was described in the following section, entitled
"Create an address directory":
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#AdrBook

And I am still struggling with how to generate *multiple* records in a
single page. So far, following the instructions exactly as described,
still yields only one record per page. What am I doing wrong?

 

[Douglas J. Steele]

I suggest asking in microsoft.public.word.mailmerge.fields

Cindy Meister, a Word MVP, is one of the experts on this topic. You could
also check her website http://homepage.hispeed.ch/cindymeister/