Excel Worksheet As Source

[MaxArk]

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

 

[Peter Jamieson]

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