Merging two groups of data from Excel

I want to merge two groups of data from an Excel spreadsheet.
The first group is dates. I have no problem with this.
For each date I want to merge one or more events.
When I use Word mail merge, 'Data Source' - 'Get Data' - 'Open Data
Source' I've tried using 'Entire Spreadsheet' or naming two named
cell ranges.
Only one named range of 'merge fields' appear when I click the 'insert
merge field' toolbar button.
Is it possible to use more than one named data range?
If so, how do you do it?
I'd very much appreciate some help.

Is it possible to use more than one named data range?

The merge itself can only have one data source.

It's hard to tell from what you have said whether you are doing a
"parent-child" type of merge. If so, then you may be able to use
macropod's tutorial - I quote his introductory remarks:


To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.


However, in your case you may well also need to reorganise your
spreadsheet to make use of that.

As an alternative, if you have Access, you might find it easier to
import your data into that and use its reporting facilities.

Peter Jamieson

http://tips.pjmsn.me.uk

wrote:
I want to merge two groups of data from an Excel spreadsheet.
The first group is dates. I have no problem with this.
For each date I want to merge one or more events.
When I use Word mail merge, 'Data Source' - 'Get Data' - 'Open Data
Source' I've tried using 'Entire Spreadsheet' or naming two named
cell ranges.
Only one named range of 'merge fields' appear when I click the 'insert
merge field' toolbar button.
Is it possible to use more than one named data range?
If so, how do you do it?
I'd very much appreciate some help.

On 11 May, 08:33, Peter Jamieson
wrote:
* Is it possible to use more than one named data range?

The merge itself can only have one data source.

It's hard to tell from what you have said whether you are doing a
"parent-child" type of merge. If so, then you may be able to use
macropod's tutorial - I quote his introductory remarks:


To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:http://www.wopr.com/index.php?showtopic=731107
orhttp://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.
*

However, in your case you may well also need to reorganise your
spreadsheet to make use of that.

As an alternative, if you have Access, you might find it easier to
import your data into that and use its reporting facilities.

Peter Jamieson

http://tips.pjmsn.me.uk



wrote:
I want to merge two groups of data from an Excel spreadsheet.
The first group is dates. *I have no problem with this.
For each date I want to merge one or more events.
When I use Word mail merge, 'Data Source' - 'Get Data' - 'Open Data
Source' I've tried using 'Entire Spreadsheet' *or naming two named
cell ranges.
Only one named range of 'merge fields' appear when I click the 'insert
merge field' toolbar button.
Is it possible to use more than one named data range?
If so, how do you do it?
I'd very much appreciate some help.- Hide quoted text -

- Show quoted text -

Thanks for the reply Peter. Haven't had a chance to try out the
tutorial yet.