mail merge using excel worksheet

A

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
 
C

Cindy M -WordMVP-

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
Click to expand...
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
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
:)
 

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

Similar Threads

VBA to do a mailmerge from a Specific Excel worksheet 0
Need Help with a VBA subroutine 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Merging from an Excel file with graphics 1
Calculated Field Always Shows Up as Zeroes 0
Need Help with Macro Security 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Mail Merge Directory Conditional Page Break 0

Top