B
BethR
Having trouble completing a mail merge in Word using an Excel
spreadsheet. In the spreadsheet there are named ranges, I have
included the column headings by defining the range that is
non-contiguous (not next to each other). When I go to complete the
merge, the range will not show up as an option to use. If I re-define
the range to not include the column headings and the range is a block
of cells next to each other, the merge still doesn't work correctly,
it assumes the merge assumes the row above the range is the column
heading row (i.e. range is A16:J101, it uses row 17 as the column
headings). Any suggestions to get around this?
spreadsheet. In the spreadsheet there are named ranges, I have
included the column headings by defining the range that is
non-contiguous (not next to each other). When I go to complete the
merge, the range will not show up as an option to use. If I re-define
the range to not include the column headings and the range is a block
of cells next to each other, the merge still doesn't work correctly,
it assumes the merge assumes the row above the range is the column
heading row (i.e. range is A16:J101, it uses row 17 as the column
headings). Any suggestions to get around this?