Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JPal JPal is offline
external usenet poster
 
Posts: 2
Default 2007 MailMerge with Excel(DDE) requires Excel file to be opened fi

We have upgraded from Office 2003 to Office 2007.
Several WORD MailMerge documents that use EXCEL with DDE are not working
correctly after the change. Under 2003 we opened the Word document, it
opened the Excel data file, the dialog to connect the two was displayed and a
YES answer displayed the MailMerge document with the underlying data
displayed.

Under 2007, the connection between Word and Excel is established only if we
manually open the Excel file first. If the Excel file is not opened before
the Word mailmerge file then the connection process fails.

All files are on a network share and that network directory has been setup
as a Trusted Location in both Word and Excel. Not sure it matters but was
one of the things I tried attempting to resolve the problem.

Any suggestions would be appreciated.
JPal

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank fields in Excel become 0 in MailMerge data file edenner Mailmerge 5 May 3rd 08 06:52 AM
Will Word mailmerge more than 255 characters from an Excel file? OkieStateLynn Mailmerge 4 February 7th 07 10:29 PM
excel--to-excel linked cells not updated in word mailmerge gijski Mailmerge 2 January 5th 07 08:00 AM
Word Mailmerge using Excel Data File a_ryan1972 Mailmerge 1 April 3rd 06 09:21 AM
mailmerge - excel datasource - other file extension? Ralf Pickel Mailmerge 1 February 14th 05 08:05 PM


All times are GMT +1. The time now is 04:57 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"