One problem is that DDE as used in Word Mailmerge can only "see" stuff in
the first worksheet in your workbook. In other words, it has never been
updated to cope with multisheet workbooks.
If you need to be abel to access any sheet other than the first sheet, you
have to use one of the other methods and work around the problems that that
can introduce (for further info. on that you can always try
http://tips.pjmsn.me.uk/t0003.htm although I would guess you are quite
familiar with that stuff).
--
Peter Jamieson
http://tips.pjmsn.me.uk
"dee" wrote in message
...
Hi,
I am doing a mail merge, using an Excel file as my source via DDE, as I
need
to retain my formatting.
My problem is that instead of displaying the options of entire spreadsheet
or a list of my named ranges, it only displays the choices of: Entire
Spreadsheet, KeyFields or MappedFields.
Why isn't is displaying my named ranges? It works fine in a small test
file, but not my larger file. Are there some limitations I am unaware of?
Thanks!
--
Thanks!
Dee