Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts

    DDE connnection error during Mail Merge (Word 2003)

    Hi All,

    I am trying to Mail Merge using MS Excel as the Source Data, there are close to 2000 records to merge. While i try connecting using DDE connection it gives me an error. I tried copying the data into a new excel sheet and merge i am still facing the same problem. I do not want to use the other connections viz ODBC or OLE since they do not support date format.

    Can you some let me know how to solve this problem or what is the cause for this error.

    Thanks
    Baiju

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DDE connnection error during Mail Merge (Word 2003)

    You can apply a date format in the merge document; you can then use OLE DB or ODBC.

    To apply a format, right-click a merge field and select Toggle Field Codes.
    You'll see something like { MERGEFIELD OrderDate }
    You can add a date format switch such as @ "MM/dd/yyyy" after the field name:
    { MERGEFIELD OrderDate @ "MM/dd/yyyy" }
    Press F9 to hide the field code and update the result.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •