Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
File in use in another program
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. -- Dave |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
File in use in another program
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." wrote in message ... 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. -- Dave |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
File in use in another program
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. -- Dave "Doug Robbins - Word MVP" wrote: 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." wrote in message ... 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. -- Dave |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
File in use in another program
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 My web site www.gmayor.com Word MVP web site http://word.mvps.org Dave K. wrote: 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. 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." wrote in message ... 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. -- Dave |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
File in use in another program
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 Previous Text Snipped to Save Bandwidth When Appropriate "Dave K." wrote in message ... 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. -- Dave |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing a file closes the program | Microsoft Word Help | |||
which program will open & view a .WPS file? | Microsoft Word Help | |||
Close a file, the program exits | New Users | |||
Program hangs on "file setup" or "file>print" | Microsoft Word Help | |||
Why does the program close when a file is closed? | Microsoft Word Help |