We have never done a mailmerge on this computer, but have 2 other computers
with Office XP which do work.
The Excel is Not password protected.
When the Data Link Properties box pops up what do we fill in for the blanks?
1. Select or enter a database name
2. Enter information to log in and the default answer is Admin
with a blank password.
What should be filled in under the connection tab?
What should be filled in under the advanced tab?
Also the all tab, what values should all those items have?
Is there some process we need to be looking to see if it is running?
"Peter Jamieson" wrote:
I'm thinking it has to do with the provider settings. I have tried to
change
this
That's interesting - Word should select "Microsoft Jet 4.0 OLE DB Provider"
automatically - if you chose something different, what was it?
Has this merge application worked before in Office XP (or in a previous
version of Office) ?
Has the Excel file been password-protected?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"jerrywhelan" wrote in message
...
We are using XP, and Office XP and unable to do a mail merge from inside
Word. The data file is an Excel spreadsheet. When going to Tools/Letters &
Mailings/Mail Merge/Use existing list
A box pops up which says "Data Link Properties" with tabs for "Provider,
Connection, Advanced, & All".
If I do test connnection, it fails with the error "Test connection failed
because of an error in initializing provider. Catastrophic Failure"
If we do not run the test and try to continue to the mail merge, Word
crashes and restarts. Either way we do not get a mail merge.
I'm thinking it has to do with the provider settings. I have tried to
change
this and I have managed to get a connection but when make any further
attempts to continue - I only get an error message or the merge screen
leaves.