Merge Word 2000

[Sandra via OfficeKB.com]

In January I was sent an Excel spreadsheet with four sheets containing data
that needs to be mail merged. Done - no problem.

In February (and each subsequent month) additional information will be added
to the appropriate sheet, ready for the next mail merge. The intention here
being that all the data is kept on one spreadsheet under the appropriate
sheets for the whole year, ie: one sheet for joiners, one sheet for leavers,
etc, etc.

In my Word folder I have four main documents, one of which I’ve called: “ABC
Joiners (shell)â€. I’ve opened the Excel data source, clicked on “Select
Methodâ€, chosen “Microsoft Excel Worksheet via Converter …….†chosen the
appropriate sheet, merged the document and saved as “ABC Joiners (final)
100107â€. This I’ve repeated three more times. Worked perfectly.

Now I’ve come to prepare February’s mail merge. On the first sheet to be
merged (say joiners) I’ve left a blank row after the last entry for January,
inserted the header row and set the print area for the new data (for February)
. Now my problems start.

Is it possible to pick up the “ABC Joiners (shell) document I created for
January and merge the February data so that I always use the same shell
letter, ie: break the link from January's data?

Is it also possible to add another header row in the same sheet and then set
the print area to pick up that data?

I have attempted the merge but in the end I just copied and pasted the
February data into another spreadsheet and merged from a new shell.

 

[Peter Jamieson]

I would forget about the "Print Area" thing as it doesn't really have any
bearing on how to specify the data you want.

The thing to do is select the header row and data you want (in Excel), and
use Excel Insert|Name|Define to define a "named range" for that area. Then,
when the converter (or whatever) asks which sheet etc. you want to use, it
should (I think) list the named ranges as well. You can give these things
useful names such as FebJoiners so it's easy to remember what they are.

I haven't done a test run through that process but try it and see.

Peter Jamieson

 

[sandralong2 via OfficeKB.com]

I'll test this tomorrow. Thank you.

I would forget about the "Print Area" thing as it doesn't really have any
bearing on how to specify the data you want.

The thing to do is select the header row and data you want (in Excel), and
use Excel Insert|Name|Define to define a "named range" for that area. Then,
when the converter (or whatever) asks which sheet etc. you want to use, it
should (I think) list the named ranges as well. You can give these things
useful names such as FebJoiners so it's easy to remember what they are.

I haven't done a test run through that process but try it and see.

Peter Jamieson

In January I was sent an Excel spreadsheet with four sheets containing
data

[quoted text clipped - 33 lines]

I have attempted the merge but in the end I just copied and pasted the
February data into another spreadsheet and merged from a new shell.