Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Select specific excel worksheet for mail merge
I need to do a mail merge, the data source is an Excel Workbook, more
specifically a single sheet in that book. When i attempt to open data source, i can only open the main document. when i select the work book the only option i get is to select "Entire Spreadsheet". But the Fields in "Insert Merge Fields" arent the firlds that I want, further they dont have any information in them at all. How do I get the fields that I want, from the sheet that I want from the actual Workbook? |
#2
|
|||
|
|||
From the Tools menu in Word, select Options and then go to the General tab
and check the box alongside the "Confirm conversions at open" item. After doing that, when you attach the data source to the mailmerge main document, you will be given a number of options for the method of connection to use. One of them (probably the DDE option) should give you the ability to access the required sheet. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Keith9360" wrote in message news I need to do a mail merge, the data source is an Excel Workbook, more specifically a single sheet in that book. When i attempt to open data source, i can only open the main document. when i select the work book the only option i get is to select "Entire Spreadsheet". But the Fields in "Insert Merge Fields" arent the firlds that I want, further they dont have any information in them at all. How do I get the fields that I want, from the sheet that I want from the actual Workbook? |
#3
|
|||
|
|||
If it is Word 2000 or earlier, check the "Select Method" box in the Open
Data Source dialog, then choose the ODBC option when offered, then click the option button in the next dialog box and check all the options. Be prepared to use "format switches" in your Word mergefields to format date and numeric data. Peter Jamieson "Keith9360" wrote in message news I need to do a mail merge, the data source is an Excel Workbook, more specifically a single sheet in that book. When i attempt to open data source, i can only open the main document. when i select the work book the only option i get is to select "Entire Spreadsheet". But the Fields in "Insert Merge Fields" arent the firlds that I want, further they dont have any information in them at all. How do I get the fields that I want, from the sheet that I want from the actual Workbook? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
How do I merge an excel document | Tables | |||
merge with excel question | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge | |||
To select data from across worksheets in a excel file for a main . | Mailmerge |