[Phil in Oz]

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

[Doug Robbins - Word MVP]

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

"Phil in Oz" Phil in wrote in message
...
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

[Phil in Oz[_2_]]

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

"Doug Robbins - Word MVP" wrote:

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

"Phil in Oz" Phil in wrote in message
...
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

[macropod]

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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Phil in Oz" wrote in message ...
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

"Doug Robbins - Word MVP" wrote:

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

"Phil in Oz" Phil in wrote in message
...
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

[Doug Robbins - Word MVP]

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

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

"macropod" wrote in message
...
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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Phil in Oz" wrote in message
...
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

"Doug Robbins - Word MVP" wrote:

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

"Phil in Oz" Phil in wrote in message
...
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