<div>
I've not tried to use 2007 for a mail merge as yet, but 2003 suffered from the same issue. &nbsp;The way that I get around it is to encapsulate your results using the text formula.<br />
=Text(A12,&quot;mmm dd, yyyy&quot;)<br />
This will force the value to text, so when word reads it, you get the correct results. &nbsp;<br />
I don't know about Word 2007, but the control codes in 2003 didn't work according to what the instructions stated.<br />
&nbsp;<br />
HTH<br />
Cal<br />

</div>


I've not tried to use 2007 for a mail merge as yet, but 2003 suffered from the same issue.  The way that I get around it is to encapsulate your results using the text formula.
=Text(A12,"mmm dd, yyyy")
This will force the value to text, so when word reads it, you get the correct results.  
I don't know about Word 2007, but the control codes in 2003 didn't work according to what the instructions stated.
 
HTH
Cal


Confirm-File-Format.gif

Data-Source.gif

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
I'm having a problem with the format of a date field when mail merging in Word 2007 with Excel data. It usually works fine, but in some cases the date shows up in Word as 39455 instead of &quot;8 January 2008&quot;. In Word, I'm using this: {MERGEFIELD &nbsp;Date_of_Inc \@ &quot;d MMMM yyyy&quot;}. In Excel, the dates come all from the same column and they are all formatted as dates (the first date type).<br />
<br />
Any clues?<br />
<br />
Thanks!<br />
J
</div>
</div>


Hi experts,

I'm having a problem with the format of a date field when mail merging in Word 2007 with Excel data. It usually works fine, but in some cases the date shows up in Word as 39455 instead of "8 January 2008". In Word, I'm using this: {MERGEFIELD  Date_of_Inc \@ "d MMMM yyyy"}. In Excel, the dates come all from the same column and they are all formatted as dates (the first date type).

Any clues?

Thanks!
J

Date format in word 2007 mail merge

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.