I need to always merge from one excel spread sheet. One feild is larger that
256 char and so I need to open the speadsheet in DDE mode. Is there a way I
can force this to happen? I know abbout manually selecting DDE when I run
merge, but I am trying to automate this as much as possible, so I am TRYING
to do this with a macro...

Here is the macro I recorded trying to do it, but when I run it, is is not
in DDE mode:.(

Sub OpenInvoice()
'
' OpenInvoice Macro
' Macro recorded 12/21/2006 by
'
   Documents.Add Template:= _
       "C:\Documents and Settings\Bruce\Application
Data\Microsoft\Templates\Notary Invoice and worksheet.dot" _
       , NewTemplate:=False, DocumentType:=0
   ActiveDocument.MailMerge.OpenDataSource Name:= _
       "C:\Documents and Settings\Bruce\My Documents\Notary - Closing
Paperwork\Notary Info2.xls" _
       , ConfirmConversions:=True, ReadOnly:=False, LinkToSource:=True, _
       AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="",
_
       WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False,
_
       Format:=wdOpenFormatAuto, Connection:="Entire Spreadsheet",
SQLStatement _
       :="", SQLStatement1:="", SubType:=wdMergeSubTypeOther
End Sub