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.
--
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.

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.

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.

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

"Simon, HK" Simon, wrote in message
...
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.