Microsoft KB Archive/220547

= WD2000: Date Incorrect Using ODBC Mail Merge with Field Date Picture Switch =

Article ID: 220547

Article Last Modified on 12/6/2000

-

APPLIES TO


 * Microsoft Word 2000 Standard Edition

-



This article was previously published under Q220547



SYMPTOMS
When you perform a Word mail merge with a data source using ODBC (Open Database Connectivity), adding a date picture switch to a merge field containing dates results in incorrect dates.

For example, the following merge field uses a picture switch:

{ MERGEFIELD Date \@ "MMMM dd, yyyy" }

which results in the following format for an example date:

July 12, 1999



WORKAROUND
To work around this problem, you can use DDE instead of ODBC.

To connect to a mail merge database using DDE, use the following steps:
 * 1) Create or open your main mail merge document.
 * 2) On the Tools menu, click Mail Merge.
 * 3) Click Get Data and then click Open Data Source.
 * 4) In the Open Data Source dialog box, go to the folder containing the data source you want to use.
 * 5) Click to select the data source.
 * 6) Click the Select method check box.
 * 7) Click Open.
 * 8) Click to select the type of database via DDE.

For example, for a Microsoft Access database, click to select MS Access Databases via DDE(*.mdb;*.mde).
 * 1) Click OK.
 * 2) Select the database table or query you want to use in your mail merge document, and then click OK.

For more information about using mail merge, click Microsoft Word Help on the Help menu, type mail merge in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
For more information about using picture switches, click Microsoft Word Help on the Help menu, type General Switches in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Keywords: kbbug kbmerge kbpending KB220547

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.