Hi
You can use MailMerge in Word with Excel table as data source.
You must have a saved Excel workbook, preferably a single-sheet one, with
your source table on first sheet. The table must have a header row, and it
must be continuous, with all data for one mail/letter/label/envelope on
single row. There can be additional info in table, so you can create p.e.
letters and envelopes for those letters, using same table as source, or you
can use some extra column to filter the rows to merge. One table can serve
as sorce for several Word Mail Merge documents.
In Word, you select from menu Tools.MailMerge and create in Mail Merge
Helper a Main Document (you are allowed to select the type of document).
Click on button Get Data, and select Open Data Source. Set File Type to MS
Excel Worksheets (*.xls), and select the worksheet with your source table.
You are allowed to select the named or cell range - when you didn't define
any named ranges before, and the workbook has a single worksheet, then it's
easy - select the whole workbook.
Now you are anounced, that there are no merge fields im Main Document, and
you are allowed to click on single button - Edit Main Document. No other
options for you there available.
Further there is no difference with typical Word Mail Merge - somehow I have
the feeling that you are confident with it.
