Note that the Word dialog listing the data in the source xls file continues
to display old information ( I removed the named range from the workbook,
dialog shows it as still present with a modified date of a couple of weeks
ago).
I wish to standardise on naming practices and leave original books/sheets
and ranges even when the data fields change. How do I break the connection to
the old data without changing filenames?
> Word 2000 mailmerge document has had two merge fields added to accommodate
> two new columns in Excel data source. Invalid Merge Field error refers to one
[quoted text clipped - 6 lines]
>
> Any ideas why additional fields not being picked up?
Peter Jamieson - 02 Dec 2004 22:56 GMT
Not sure I have completely understood, but...
> How do I break the connection to
> the old data without changing filenames?
Go into the MailMergeHelper, click Create, then choose Restore to Normal
Word Document
Peter Jamieson
> Note that the Word dialog listing the data in the source xls file
> continues
[quoted text clipped - 20 lines]
>>
>> Any ideas why additional fields not being picked up?
I suspect the best you can do is to go through the connection process
again - you will lose any filter/sort criteria though.
Peter Jamieson
> Word 2000 mailmerge document has had two merge fields added to accommodate
> two new columns in Excel data source. Invalid Merge Field error refers to
[quoted text clipped - 8 lines]
>
> Any ideas why additional fields not being picked up?