[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 Ive called: €œABC
Joiners (shell)€�. Ive 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 Ive repeated three more times. Worked perfectly.

Now Ive come to prepare Februarys mail merge. On the first sheet to be
merged (say joiners) Ive 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.

--
Message posted via http://www.officekb.com

[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
"Sandra via OfficeKB.com" u5657@uwe wrote in message
news:6d781d1abb9ab@uwe...
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.

--
Message posted via http://www.officekb.com

[sandralong2 via OfficeKB.com]

I'll test this tomorrow. Thank you.

Peter Jamieson wrote:
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.

--
Message posted via http://www.officekb.com