Merging from Excel to Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
Back
Top