Multiple worksheets in Data Merge

[laspeyer]

I am attempting to create form letters using the Microsfot Word Data
Merge Manager. All of the data is in one Excel Workbook, but it is
spread across many worksheets of that workbook. The Data Merge Manager
seems to only be able to open one Worksheet at a time (even if I
select "Entire Workbook", only the Headers from the first worksheet
are visible.) If I use headers from different worksheets in the merge
document (by first opening one and then another) then I get a "Merge
Fireld Error" dialogue box when attempting to merge.

Details:
Microsoft Word 2004 for Mac Version 11.3 (061213)
Microsoft Excel 2004 for Mac Version 11.3.3 (061213)
Mac OS X Verion 10.4.10

Thank you so much for any help. Feel free to reply either on the list
or by e-mail ( laspeyer (AT) gmail.com ) or to point me to a more
appropriate list.

 

[db ´¯`·.. >]

what you describe is
not really a problem.

you need to either
separate the worksheets
into their own individual
data tables/files

of

merge the data in the
worksheets into one table.

however, if you use msaccess,
it can program it to create
your labels and combine the
data from all the tables beforehand.

you see, if you are simply using
one table and one form/template
then word and excel work pretty
good.

but using more tables than
the simplistic method above
or extrapolating complex
information from data
requires a database.


--

<)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><)))º>

..