Select specific excel worksheet for mail merge

[Keith9360]

I need to do a mail merge, the data source is an Excel Workbook, more
specifically a single sheet in that book. When i attempt to open data
source, i can only open the main document. when i select the work book the
only option i get is to select "Entire Spreadsheet". But the Fields in
"Insert Merge Fields" arent the firlds that I want, further they dont have
any information in them at all. How do I get the fields that I want, from
the sheet that I want from the actual Workbook?

 

[Doug Robbins]

From the Tools menu in Word, select Options and then go to the General tab
and check the box alongside the "Confirm conversions at open" item. After
doing that, when you attach the data source to the mailmerge main document,
you will be given a number of options for the method of connection to use.
One of them (probably the DDE option) should give you the ability to access
the required sheet.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Peter Jamieson]

If it is Word 2000 or earlier, check the "Select Method" box in the Open
Data Source dialog, then choose the ODBC option when offered, then click the
option button in the next dialog box and check all the options. Be prepared
to use "format switches" in your Word mergefields to format date and numeric
data.

Peter Jamieson