MailMerge - repeating information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil in Oz - 20 Feb 2008 00:52 GMT

Hello:

I have a mail merge set up to produce two reports.

Report 1 contains a table along the lines of:

Student ID Raw Mark Scaled Mark Pass/Fail etc:

Report 2 contains a simplified version of the same information:

Student ID Pass/Fail

which is for distribution to students (ie, stuff they don't need to know has
been stripped off it)

The data is merged in from an Excel spreadsheet - that aspect words fine.
I'm using 'NextRecord' to move through the data records, and the result is
exactly what I'm after: a table listing all of the above, with the results
dragged in from Excel.

To save on time and effort, I would like these 2 reports to be part of the
same document, rather than 2 separate docs. However, this would require one
of two options:

Resetting the mail merge back to the first record, or;

Having cells in the second table reflect the contents of relevant cells in
the first table.

Either would word admirably in theory: but I can't get either of these to
work in practice.

Does anyone have any suggestions?

Thanks,

Phil

Word 2002
XP Home

Reply to this Message

Doug Robbins - Word MVP - 20 Feb 2008 04:22 GMT

To answer your question, it is not possible to move backwards through the
data source.

The way that you are doing it now is probably as good as any. I suppose
however, you could just take the first document, the more complete one, copy
the table and paste it into the document at a second location and then from
that new table, delete the columns that you do not need.

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

> Hello:
>
[quoted text clipped - 38 lines]
> Word 2002
> XP Home

Reply to this Message

Phil in Oz - 20 Feb 2008 06:09 GMT

Thanks for the speedy reply Doug;

I think you're right - a macro that copied all the information, then deleted
the extra columns would probably work a treat.

I would however like to further explore the idea of linking cells in the
second table to ones in the first: I see there's a forum for Tables, so I'll
see what I can find out there!

Thanks again for your help,

Phil

> To answer your question, it is not possible to move backwards through the
> data source.
[quoted text clipped - 45 lines]
> > Word 2002
> > XP Home

Reply to this Message

macropod - 20 Feb 2008 07:12 GMT

Hi Phil,

You could simply replicate the required mergefields in the second table. That will be a lot easier than trying to link
(cross-reference) the cell contents, especially where text is concerned.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

> Thanks for the speedy reply Doug;
>
[quoted text clipped - 58 lines]
>> > Word 2002
>> > XP Home

Reply to this Message

Doug Robbins - Word MVP - 20 Feb 2008 11:39 GMT

Not when he is using Next Record fields in the first table in the document.

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 Phil,
>
[quoted text clipped - 78 lines]
>>> > Word 2002
>>> > XP Home

Reply to this Message