Complicated (to me) merge

[philomaher]

Hi all,

I hope the title has drawn in the right people. I have a number of
tables within access and would like to create word documents from
these, that I can do, except in this case there are a couple of
complications which I will do my best to describe:

I wish to create 700 documents from my data which will be about 1400
rows in access. The documents are broken down as follows:

<<ID>> <<applicant name>> <<Institution Name>>
<<Title>>
Abstract
<<Abstract>>
<<Review #1>>
<<Reviewer #1 Name>> <<Rating Text #1>>
<<Review #2>>
<<Reviewer #2 Name>> <<Rating Text #2>>

There will be a minimum number of 2 reviews per document (ID) but I
can't repeat the document information (lines 1 to 4)

Can anyone help me out with this? Or should this be posted in the
access area?

Thanks in advance

 

[Doug Robbins - Word MVP]

You should use a Report in Access for this. It is far easier to do it there
than to try and do it with mail merge in Word that really does not have this
capability.

However, if you are a masochist,

See the "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


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


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

 

[philomaher]

I'll give it a try. Thanks for your help

You should use a Report in Access for this. It is far easier to do it there
than to try and do it with mail merge in Word that really does not have this
capability.

However, if you are a masochist,

See the "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


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


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