Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2007

Tip: Looking for answers? Try searching our database.

word 2007 slow opening a mailmerge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
joe schmo - 09 Mar 2007 18:43 GMT
The mail merge was initially created with word/excel 2000.  Now I have
upgraded to Office 2007.  When I open the word doc with the mail merge, it
hangs fora about 45sec before the excel and word doc is opened.  Is there a
reason for this and how can I fix it?

thanks
Peter Jamieson - 09 Mar 2007 19:07 GMT
> Is there a
> reason for this and how can I fix it?

I don't know for sure, but at the moment Word is probably getting its data
using an obsolescent method (DDE) from an Excel format (.xls) that should
also be considered obsolescent now that you are using Office 2007.

In your situation, I would probably
a. make sure I had a backup copy of my Word 2000 and Excel 2000 documents
b. open my Excel 2000 document in Excel 2007 and save it in the native
Excel 2007 format.
c. open my Word 2000 document and try to connect to that new Excel 2007
document. If successful, save the Word document in Word 2007 format (.docx,
or .docm if it contains macros)

However,  when you use DDE, Word tends to display the data more or less as
you saw it in Excel. Once you have done (c), the chances are that you will
no longer be using DDE and all your field results will look different. At
that point I suggest you have a look at http://tips.pjmsn.me.uk/t0003.htm -
it doesn't cover Office 2007, and in particular, how to change the way Word
2007 connects to Excel  2007, but I believe most of the material is still
relevant.

Peter Jamieson

> The mail merge was initially created with word/excel 2000.  Now I have
> upgraded to Office 2007.  When I open the word doc with the mail merge, it
[quoted text clipped - 3 lines]
>
> thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.