mail merge using excel worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

annie - 18 Nov 2003 13:09 GMT

Use mailmerge with sheet1 of a workbook OK, but how do I
select sheet2 to be the data for the workbook?

Using office 2000 and Windows XP

Reply to this Message

Cindy M -WordMVP- - 18 Nov 2003 16:53 GMT

Hi Annie,

> Use mailmerge with sheet1 of a workbook OK, but how do I
> select sheet2 to be the data for the workbook?
>
> Using office 2000 and Windows XP

This will only work using an ODBC connection to the data.
This means you may lose some numeric or date formatting,
and will have to use formatting switches in the merge
fields to get it back.

Activate the "Select method" checkbox in the Open Data
Source dialog box. Now you can choose ODBC. If you don't
see your sheet listed in the dialog box that follows, click
"Options" and activate "System tables".

Cindy Meister

Signature

INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 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

:-)

Reply to this Message