Complicated (to me) merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

philomaher@gmail.com - 11 Oct 2006 18:01 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 11 Oct 2006 20:06 GMT

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

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

> Hi all,
>
[quoted text clipped - 22 lines]
>
> Thanks in advance

Reply to this Message

philomaher@gmail.com - 11 Oct 2006 20:43 GMT

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
[quoted text clipped - 47 lines]
> >
> > Thanks in advance

Reply to this Message