Excel datasource

S

simonc

When you select an Excel workbook as a datasource for a mailmerge you have
the option of specifying a range of cells instead of the Entire Spreadsheet.
If the workbook has multiple worksheets what is the correct syntax for
specifying a range of cells in a particular worksheet? I have tried a variety
of quotes, exclamation marks, square brackets but everything gives an error.

I am using Word and Excel 2000.

Grateful for any help.
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?c2ltb25j?=,
When you select an Excel workbook as a datasource for a mailmerge you have
the option of specifying a range of cells instead of the Entire Spreadsheet.
If the workbook has multiple worksheets what is the correct syntax for
specifying a range of cells in a particular worksheet? I have tried a variety
of quotes, exclamation marks, square brackets but everything gives an error.

I am using Word and Excel 2000.
Even though this dialog box says this, I can't recall ever being able to find
something that worked for a DDE connection. It's possible with the other two
types of connection available for Excel in Office 2000: ODBC and Word's internal
spreadsheet converter. Activate "Select method" in Open Data source.
- If you choose ODBC, click "Options" and activate the checkboxes in the
dialog box that pops up. You should get a choice of spreadsheet range names and
sheet names

- If you choose the converter, you can type in a cell reference in R1C1
syntax, as I recall

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top