[Bstice]

I am trying to do a mail merge with an excel sheet that has several sheets.
I am sure there is a way to specify which sheet to use when the merge helper
asks if I want to use the entire sheet or not. I have tried plugging in the
following which is the sheet name and cell range:

'Consolidated New.'!1:1475

This causes the action to time out and the DDE connection to break. If I
just want to use a range of cells on one sheet in a workbook with multiple
sheets, what do I need to do to process a mail merge. I know that you can
pull the sheet out by itself, but it would be nice if that didn't have to
happen. Thanks for your help.