Office Letter, Excel Data

[Tim Chandler]

Hi all,

I'm trying to come up with a way to create a nice form letter (or
report) with data (much like a Mail Merge might do), using Excel as a
datasource. The Excel sheet has several worksheets within it, though,
and I'm finding it difficult to specify the range I'm looking to use
for data.

Has anyone used Excel sheets for datasources for Mail Merge, with data
other than on the main sheet? Is there a better (VBA) way to do this?
My main objective is to use Excel as the data entry for our
salespeople, but use Word to create a report for the clients to see.

Thanks!
Tim Chandler
(e-mail address removed)

 

[Cindy Meister -WordMVP-]

Hi Tim,

Has anyone used Excel sheets for datasources for Mail Merge, with data
other than on the main sheet?

It's possible, but not using DDE (default up to Word 2002) as the
connection method.

Your best bet is to assign the data range a range name, then use an ODBC
connection which will make it fairly easy to link up to the range.

Users might complain about the extra steps needed to make this
connection, and you may run into data formatting issues. In order to
give you any information on this, though, we'd need to know the
version(s) of Word involved.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

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