Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Form Letter In Word / Data Source in Excel ... cannot edit records
I have a mail-merge form letter I've set up in Word 2003, using data in an
Excel 2003 worksheet. When I click the "Open Data Source" button, it brings a pop-up window with all the records, but if I select a record, the "Edit" button is "shadowed-out" so I can't use it. What do I need to do here? Can I convert the Excel worksheet to some other format? Seems to be a new "glitch" from Office 2000 to 2003. |
#2
|
|||
|
|||
I've always edited my data source in Excel.
-- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "John" wrote in message ... I have a mail-merge form letter I've set up in Word 2003, using data in an Excel 2003 worksheet. When I click the "Open Data Source" button, it brings a pop-up window with all the records, but if I select a record, the "Edit" button is "shadowed-out" so I can't use it. What do I need to do here? Can I convert the Excel worksheet to some other format? Seems to be a new "glitch" from Office 2000 to 2003. |
#3
|
|||
|
|||
I used to have a word-excel mail merge file working together for months. When
I click the word file, the excel file opens automatically. I can freely switch between them to edit or print! When I close the word file, the excel file will also close automatically. Yesterday, I created another set of mail merge files but this time, the excel file did not start automatically and was not able to edit just like John's case. Have to close the word file in order to open the excel file for editing. I have checked around but still not able to figure out what's wrong. I think this should be related to file link problem. Anyone can help? I'm using Office 2003 "Charles Kenyon" wrote: I've always edited my data source in Excel. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "John" wrote in message ... I have a mail-merge form letter I've set up in Word 2003, using data in an Excel 2003 worksheet. When I click the "Open Data Source" button, it brings a pop-up window with all the records, but if I select a record, the "Edit" button is "shadowed-out" so I can't use it. What do I need to do here? Can I convert the Excel worksheet to some other format? Seems to be a new "glitch" from Office 2000 to 2003. |
#4
|
|||
|
|||
You have to open the Excel sheet using DDE - check Word
Tools|Options|General|"Confirm conversion at open", reconnect tot he spreadsheet, and select the DDE option when it is offered. Peter Jamieson "John" wrote in message ... I have a mail-merge form letter I've set up in Word 2003, using data in an Excel 2003 worksheet. When I click the "Open Data Source" button, it brings a pop-up window with all the records, but if I select a record, the "Edit" button is "shadowed-out" so I can't use it. What do I need to do here? Can I convert the Excel worksheet to some other format? Seems to be a new "glitch" from Office 2000 to 2003. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a form in excel and word that locks in the user's data so . | Microsoft Word Help | |||
Create a form in excel and word that locks in the user's data so . | Microsoft Word Help | |||
Format Excel data for merging in Word | Mailmerge | |||
Continuous breaks convert to next page breaks | Microsoft Word Help | |||
Linking Excel data to tables in Word | Tables |