Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging two groups of data from Excel
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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging two groups of data from Excel
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Filtered Excel Data | Mailmerge | |||
merging highlighted data from excel | Mailmerge | |||
Changes are not reflected when merging using Excel as data source | Mailmerge | |||
Merging data from Excel to Word | Microsoft Word Help | |||
Merging Data from Excel into words | Mailmerge |