[Doug Robbins - Word MVP]

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, select the DDE
option in the dialog that appears asking be what method the connection
should be made.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

wrote in message
...
More info.. switched from Office 2000 to Office XP. It seems that
documents created in Office 2000 automatically open the Excel data
source. In Office XP, it seems that the data source does not load
automatically.

Anyone else encounter this? Any solutions?