I’m at work and trying to create a mail merge of labels. I have done this before so I do know what I’m doing. I have a large Excel spreadsheet that I’m trying to use as the data source. When I go to open that data file from the mail merge screen in word, it opens Excel but not the file. It used to work but stopped about 4 months ago. I’m getting tired of going to someone else’s computer and emailing the data files to myself.
Details: Office 97 on Win98 computers. No shared drives.
Any ideas?
Hmm, that’s tricky. Have you installed Office 97 Service Release 1 and 2b? Does this happen with all merged Excel files or only certain ones? Do you ever get any error messages?
You might want to try repairing Office by running setup.exe from the CD.
Haven’t installed either but both Word and Excel list themselves as version SR-2
It’s happened with every Excel file I’ve tried.
The only error message I get is when I, in disgust, close Excel after it doesn’t open my source file. It says, “Word could not establish a DDE connection to MS Excel to complete the current task.” I knew that…
I suppose I may have to reinstall but am not really excited about doing so if there is a way around it.
Is Ignore other applications checked under Tools|Options|General in Excel?
Bless you Number! That did it. How the Heck did you figure that one out?
I plugged that error message into Tobin’s Spirit Gui…er, I mean the Microsoft Knowledge Base.
Hangs head and looks sheepish
Thank you for your help! I should have done that myself but for some reason, I’ve never had any luck with the knowledge base.
Don’t feel bad: the trick with MS’ Knowledge Base is being able to guess what they call things. They don’t use the same terms for things that most normal human beings use. They seem to use a specific dialect called “Microsoft-Speak.” Once you get a feel for it, the KB is actually very useful, but one’s initial forays into it are usually an exercise in frustration!
>> I suppose I may have to reinstall but am not really excited about doing so if there is a way around it.
I have reinstalled and repaired excel and word several times and it just takes a few minutes. Don’t be afraid to do it. It’s painless.