If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hidden columns in Excel Source
Can hidden columns in an Excel worksheet be used in a Word mail merge?
Jenn |
#2
|
|||
|
|||
Excel Worksheet As Source
Suppose the data you need is in row 5, column A to row 20 (say) column
H, then you can create a range name that references A5:H20 in the worksheet. Then when you connect from Word you should be able to select that range in the "Tables" dialog that appears, assuming you are using Word 2002 or later. If you are not in a position to insert a range name into the worksheet yourself, there may be another way, but try that first if possible. Peter Jamieson http://tips.pjmsn.me.uk MaxArk wrote: I need to use an Excel worksheet as a mailmerge source. The header row for the database is on row 5. Rows 1-4 hold critical calculation information and cannot be removed. Is there a way that Word can recognize row 5 as the field information rather than row 1? Jenn |
Thread Tools | |
Display Modes | |
|
|