 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2005Form 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. I've always edited my data source in Excel.  SignatureCharles 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. >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 [quoted text clipped - 4 lines] > I convert the Excel worksheet to some other format? Seems to be a new > "glitch" from Office 2000 to 2003. 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 > I've always edited my data source in Excel. > >I have a mail-merge form letter I've set up in Word 2003, using data in an [quoted text clipped - 5 lines] > > I convert the Excel worksheet to some other format? Seems to be a new > > "glitch" from Office 2000 to 2003. 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 >I used to have a word-excel mail merge file working together for months. >When [quoted text clipped - 28 lines] >> > I convert the Excel worksheet to some other format? Seems to be a new >> > "glitch" from Office 2000 to 2003. 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 >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 [quoted text clipped - 4 lines] > I convert the Excel worksheet to some other format? Seems to be a new > "glitch" from Office 2000 to 2003. |
Reply to this Message |
 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.