Add related subform to mail merge document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carolyn M - 19 Mar 2006 03:51 GMT

I have mail merged a document into Word from an Access query. I now want to
add a subform that would typcially have several records for each one related
record in the Word document. They are linked by StudentID. It is a one to
many relationship. Can I identify another source for another merge for the
subform?

Signature

Col

Reply to this Message

Doug Robbins - Word MVP - 19 Mar 2006 09:12 GMT

I would just use an Access Report for the whole thing. Word does not have
the ability to do it easily.

See http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Or "Group Multiple items for a single condition" item on fellow MVP Cindy
Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Signature

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

>I have mail merged a document into Word from an Access query. I now want
>to
[quoted text clipped - 5 lines]
> the
> subform?

Reply to this Message

Carolyn M - 19 Mar 2006 13:29 GMT

Thanks for your help. I am more familiar with Access and have done lots of
reports incuding adding subforms. Where I am struggling there is how to
format the text boxes to a letter layout and inserting the necessary fields
at the same time. I will pose my question of formatting to the Access
people. Thanks again.

Signature

Col

> I would just use an Access Report for the whole thing. Word does not have
> the ability to do it easily.
[quoted text clipped - 19 lines]
> > the
> > subform?

Reply to this Message