Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2004

Tip: Looking for answers? Try searching our database.

Mailmerge wont see Added Excel Data source Columns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thatdampwood - 02 Dec 2004 14:35 GMT
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?
Thatdampwood - 02 Dec 2004 15:11 GMT
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?
Peter Jamieson - 02 Dec 2004 22:54 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.