Excel XP file as data source in Word mail merge

[Yves Leclerc]

I have a client where the Word XP mail merge no longer seems to able to
access an Excel XP file for use as the data source in the mail merge. I
need to re-format the file by opening the file with "Format for mail merge"
option in Word first and saving it. Then, doing the mail merge with this
re-formatted file works.

How can I get the file to open directly in mail merge?

 

[Bob Buckland ?:-\)]

Hi Yves,

You may want to also post this in the Word Mailmerge newsgroup,
news://msnews.microsoft.com/microsoft.public.word.mailmerge.fields

======
I have a client where the Word XP mail merge no longer seems to able to
access an Excel XP file for use as the data source in the mail merge. I
need to re-format the file by opening the file with "Format for mail merge"
option in Word first and saving it. Then, doing the mail merge with this
re-formatted file works.

How can I get the file to open directly in mail merge?

--
Y.>>
--
Let us know if this helped you,

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

Office 2003 Editions explained
http://www.microsoft.com/uk/office/editions.mspx

 

[Yves Leclerc]

Thank you! I was not sure where to post.

Y.