Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mailmerge wont see Added Excel Data source Columns
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 of the new fields 'This merge field is used in the main document, but it does not exist in the data source.' Well it does! The data is in custdata.xls in sheet1 in a named range 'custdata' Any ideas why additional fields not being picked up? |
#2
|
|||
|
|||
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? "Thatdampwood" wrote: 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 of the new fields 'This merge field is used in the main document, but it does not exist in the data source.' Well it does! The data is in custdata.xls in sheet1 in a named range 'custdata' Any ideas why additional fields not being picked up? |
#3
|
|||
|
|||
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 "Thatdampwood" wrote in message ... 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 of the new fields 'This merge field is used in the main document, but it does not exist in the data source.' Well it does! The data is in custdata.xls in sheet1 in a named range 'custdata' Any ideas why additional fields not being picked up? |
#4
|
|||
|
|||
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 "Thatdampwood" wrote in message news 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? "Thatdampwood" wrote: 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 of the new fields 'This merge field is used in the main document, but it does not exist in the data source.' Well it does! The data is in custdata.xls in sheet1 in a named range 'custdata' Any ideas why additional fields not being picked up? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Table dialog box after choosing data source | Mailmerge | |||
Mail Merge with no header row in the Excel Data | Mailmerge | |||
disconnect a data source | Mailmerge | |||
Merge Data Source path | Mailmerge | |||
Export table data to Excel | Tables |