Why wont Word open Excel data source in mailmerge?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am following the Help step by step, but each time i try to open data source
it wont. I have saved the correct version in Excel and have renamed it etc
 
MOSH

"won't" means what?

Do you get an error message?

You cannot browse to an Excel file and use it?

You have no ODBC driver for Excel?

If the latter, you may have to re-configure and add that driver.

Go to Control Panel(Start>Settings>Control Panel) and double-click on Data
Sources(ODBC).

In User DSN what do you see for drivers?

If no Excel, click on Add and find Excel on the list(not Excel do). Select
and "Finish".

Now enter "Excel Files"(no quotes) in the Data Source dialog.

Ok and Apply your way out.

Gord Dibben Excel MVP
 
-----Original Message-----
I am following the Help step by step, but each time i try to open data source
it wont. I have saved the correct version in Excel and have renamed it etc
.
Click to expand...
You didn't say which versions. They must be the same.
 
If you are using Office 97, and everything done is correctly, then the Excel
file should open and be represented on the Windows taskbar. In this event,
if you dont see it, you must have set things up incorrectly. I never used
Office 2000
If you are using Office 2002 or 2003, the Excel file opens in the background
and you may not see it. However, on either the MailMerge toolbar, or the
MailMerge taskpane is the Edit Recipients List utility. Click it and you
should see all your Merge recipients. If you see nothing, then once again
you did something incorrectly.
By the way, in Word, go to Tools, Options, General and put a check in
Confirm Conversion at Open. You will be asked during the "opening" of the
Excel file to choose a data transfer protocol. Choose DDE.
 
Back
Top