Merging from Excel to Word

L

L Parsons

I am using Excel as a data source for mail Merge letters and have multiple sheets in each Excel document.

I am not sure how to select a specific sheet when merging to avoid having to use the entire document and then seperating what I do and don't actually need

I have also thought of using a new template each time I need to merge and copying the info over but there must be an easier option.
 
D

Debra Dalgleish

The steps vary for different versions of Excel, but if you select ODBC
as the data source, you can use a named range on any worksheet in the
Excel workbook. In the Mail Merge, after you select your Excel file as a
data source, you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

There are instructions here, to name a range:

http://www.contextures.com/xlNames01.html

Also, there's Mail Merge information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm
 
L

L Parsons

Thanks a lot. Much appreciated

----- Debra Dalgleish wrote: ----

The steps vary for different versions of Excel, but if you select ODBC
as the data source, you can use a named range on any worksheet in the
Excel workbook. In the Mail Merge, after you select your Excel file as a
data source, you should see a 'Confirm Data Source' dialog box
(If you don't see the dialog box, change the setting in Word -
under Tools>Options, General -- add a check mark t
'Confirm Conversion at Open'

There are instructions here, to name a range

http://www.contextures.com/xlNames01.htm

Also, there's Mail Merge information on the Word MVP site

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.ht

L Parsons wrote
 
Top