File in use in another program

[Dave K.]

I am trying to create labels using mailmerge to access addresses stored in a
Works Spreadsheet. Word 2002 takes me through the normal dialog until Open
Data Sources, then tells me "This mail merge list cannot be opened because it
is in use in another program. Please close it in the other program and try
again." This occurs when the spreadsheet itself is not open or running, so
far as I can tell. Only Word is running. How do I release the spreadsheet
from whatever program has seized it so that Word/mailmerge can open it? I
don't recognize anything in Windows Task Manager/Processes that appears to be
the culprit. Thanks in advance.

 

[Doug Robbins - Word MVP]

Have you tried re-starting your computer and then attempt doing the
mailmerge before anything else.

I do not know anything about Works, but in it, can you save the file as a
text file or in some other format that can be used by Word as a data source,
or, can you copy the contents of the Spreadsheet and then paste it into a
Word document, where I would expect that it would appear as a table, or
could be converted to a table that you can then use as a data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Dave K.]

I didn't restart but did save the Works spreadsheet file as a Word document
as you suggested and it worked! I was able to open the doc file and print
labels as well as save the new Word file for future use. Why Word believed
the spreadsheet was in use by another program remains unclear, but at least I
was able to work around the problem. Thank you so much.

 

[Graham Mayor]

Word has no compatibility with Works data sources in their native formats,
unless the notoriously problematical Works add-in for Word is installed.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Rich/rerat]

Dave K,
If you plan to use Works Spreadsheet program to create a Data base for Word,
you can't save it in its normal default file type *.XLR.

You will need save it as a Excel (*.XLS), text, or Comma Separated Value
(*.CSV) file.

--
Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) <message rule>