Merge Printing Part of Spreadsheet

[paul bennett]

Temporary working on Excel at Work. Need to write to a number of people on
the spreadsheet. So far, I've sorted, then copied data into another
spreadsheet. Then when I've done mail merge, where it says Entire
Worksheet, I click on this. Is there a way of marking the block in the
original worksheet/or stating the cells. If stating the Cells, what do you
put A1 to A10, then rows A1 to A10?

Some assistance would be much appreciated. (or by the way in simple terms,
I'm a bit thick when it comes to Excel)

 

[Debra Dalgleish]

You could try naming the range of cells. There are instructions here:

http://www.contextures.com/xlNames01.html