MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Ted O`Brien on January 14, 2002 7:40 PM

Made list in excel, saved, can bring up ok,in MS Word box Select Worksheet or Table comes up, I put in Sheet 1, have tried my save name also, another box MS Works comes up, says name invalid, rename try again, did, same results. How can I get MS Word to recognize.

Posted by Lewis(1) on January 15, 2002 7:53 AM

Not clear what you are trying to do (NT)

Posted by Ted on January 16, 2002 7:20 PM

Re: Not clear what you are trying to do (NT)

I want to use the excel address list in MS Works mail merge program. Thanks

Posted by Lewis (1) on January 17, 2002 2:41 AM

Try This to use Works address book in MS Word

Its a bit long winded but try:
Open the address book you want to use in Works
Save as text & commas (.csv)
Open Excel
File/open (find the .csv file you have just created)

This lists all the data but has no column headers, so you will need to insert a row above the data and manually put in the headers. I dont think spaces are a good idea. Save as yourfilename.xls file

Open Word set up your document
on mail merge when you select get data click on open data souce and then select yourfilename.xls
The headers you have put in should then be the mergefield names.

Good Luck

Posted by Ted on January 17, 2002 7:34 PM

Re: Try This to use Works address book in MS Word

Thanks for reply Lewis, everything is working fine now