Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
re-establish a DDE connection
Word and Excel 2002 SP3
Excel document has formatting, dates, currency, SSN, etc. to merge into Word, so we need to use DDE to retain those formats. Until recently, merges worked fine. User thinks a co-worker did something to my machine. When she merges with some, not all, of her letters, she gets the dreaded Word could not re-establish a DDE connection to Microsoft Excel to complete the current task. - In Excel, Ignore Other Applications is unchecked. - Confirm Conversion at Open is checked. - The Excel file is 670KB. - To copy just data to a new spreadsheet would cause a lot of formatting to need re-creation, so I have copied (Select All) the spreadsheet to a new workbook. - I inserted the letter into a new document. - I renamed normal.dot. In one case the letter inserted into a new document worked, but this method did not work using another of her letters. I have no idea why all the letters worked fine up until last Friday. Short of reinstalling the suite, which I doubt would work anyway, what else is there to try? Im stumped! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word could not re-establish a DDE Connection | Mailmerge | |||
can not establish a DDE connection | Mailmerge | |||
..cannot re-establish DDE Connection | Mailmerge | |||
how do you re-establish a DDE connection | Mailmerge | |||
re-establish DDE connection | Mailmerge |