Can I mail merge from different worksheets in an excel workbook?

J

JavaProgMan

Can I mail merge from different worksheets in an excel workbook into a single
word document? So, the merged documents would have merge fields coming from
different worksheets in the workbook.
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?SmF2YVByb2dNYW4=?=,
Can I mail merge from different worksheets in an excel workbook into a single
word document? So, the merged documents would have merge fields coming from
different worksheets in the workbook.
Click to expand...
No. word can only link to a single data table to use as a data source. You
should consider linking all these various ranges into a single sheet for the
purposes of mail merge.

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

Similar Threads

Merging from an Excel file with graphics 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Merge Excel file into Word Document 3
Mail Merge Directory Conditional Page Break 0
Page numbering with Merged Document and IF statements 1
Start a mail merge upon opening the document 1
Mail Merge skipping records/sending one at a time 0
Mail Merging into PowerPoint 0

Top