Actually, I'm not mapping the fields. I was incorrect in that statement.
OK, the "mapping" thing really threw me.
I can't currently replicate this (I only have a really simple example here
though) but maybe you could spell out a few things - or even send the .doc
and .xls to my despammed address.
Are you using the default connection method (OLEDB)? If you are connecting
via the converter, I think you may experience missing data problems
I
> > > have re-mapped the fields to the Excel file, however the fields do no
> > > pull data.
By "re-mapped" can we assume you re-inserted them from the drop-down list in
Word?
> > > Here's the weird thing - those two fields are part of a
> > > four field named reference - a named range on one of the other tabs in
> > > the main Excel ss.
By a "four field named reference" do you mean a 4-column area with a range
name, or are you doing something more complicated than that?
> > > were overwritten) will not. When I click on the Mail Merge Recipients
> > > toolbar button it brings up the Data tab in Excel - all the fields map
> > > EXCEPT the two that were overwritten.
Do you mean that the two overwritten fields are simply absent from the
recipient list, that the column headings are there but the data is missing,
or something else?
--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/
> Actually, I'm not mapping the fields. I was incorrect in that statement.
>
[quoted text clipped - 36 lines]
> > > Thanks much!
> > > Michael