Excel datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

simonc - 03 Nov 2004 10:27 GMT

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.

Reply to this Message

Cindy M -WordMVP- - 04 Nov 2004 12:00 GMT

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.
[quoted text clipped - 3 lines]
>
> 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 :-)

Reply to this Message