Merging data from Excel...

[Mike]

Ok, I'm going crazy:

I have an Excel ss with multiple tabs. One tab - the DATA tab -
contains formulas that pull data from the other tabs (I use VLOOKUP
function a lot). This way, my users can add data to the other tabs
and not mess up the actual tab used for the mail merge - the Data tab.

This (is) was working great. I created the Word doc and merged all
the fields. A day or so ago someone manually typed in information
overwriting two of the mail merge fields, and then saved the doc. I
have re-mapped the fields to the Excel file, however the fields do no
pull data. 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. In the mail merge doc, two of the four mail merge
fields will pull data from the Data tab, but the other two (the 2 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.

I have remapped the fields in Word. I've reconfigured the data
source. I've reconfigured the named range on the excel tab. Nothing
is working. I could see if the data wasn't showing up in the formula
on the Data tab, but it is so how can the data show up in the formula
on the "Data" tab and not in the Word mail merge?!?!

Please help! Version is Office 2002 on Windows XP Pro.

Thanks much!
Michael

 

[Peter Jamieson]

If you are using mapped fields, are you using the \m switch in the
appropriate MERGEFIELD fields to specify that the field name is mapped?

(I'm quite interested to know why you are mapping fields at all)

 

[Mike]

Actually, I'm not mapping the fields. I was incorrect in that statement.

 

[Peter Jamieson]

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
By "re-mapped" can we assume you re-inserted them from the drop-down list in
Word?

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?

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?