Mailmerge Excel to Word

[Lyn Davenport]

I'm trying to merge addresses from Excel XP to Word XP by
way of the mail merge wizard. It says it needs an import
converter. I can't find anyway or anything to make it
work. Any solutions??
Thanks,
Lyn

 

[Cindy M -WordMVP-]

Hi Lyn,

I'm trying to merge addresses from Excel XP to Word XP by
way of the mail merge wizard. It says it needs an import
converter.

Oh, that sounds like fun! Are you selecting a connection
method (Word's internal spreadsheet converter), by any
chance?

If not, if you go to Tools/Options/General and activate
"Confirm conversions on open" you should get a list once
you've selected the Excel sheet. What entries do you see in
this list? Does selecting DDE or ODBC (assuming they're
there) give you a better result?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail