My fix for this has always been to format to text in the source, not using Word.
Define a new column (might be hidden) and use the text function (see http://www.techonthenet.com/excel/formulas/text.php for example) to format the value in that column to a string. Then use that column as source for your mailmerge, like any other fields.
Some persons prefer to use the formatting options offered by Word. That's a viable alternative.
And I assume the DDE-option still works in Office 2007, but I don't know for sure.
More on these three options (in reverse sequence) in http://office.microsoft.com/en-us/word/HA011164951033.aspx
I am attempting to Mail Merge for appointment sheets.
One of the fields has the appointment time and in the Excel sheet these list times of day (ex. 11:00 AM, 10:15 AM). They are formatted in Excel as a time.
When I Mail Merge the Excel sheet into Microsoft Word, the times come up as a long decimal number (for example, 11:00 AM appears as 0.45833333333).
Does anyone know how to fix this for Microsoft Office Suite 2007?