Formatting Merged field in mail merge

[Guest]

I have a excel list of information to mail merge in word 2007

The ORDERDATE field in word the formatting of the date & month is reversed
like a US Date.

Need to format Date as dd/mm/yy format.

Thanks

 

[Graham Mayor]

Add a date formatting switch to the field - see
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Henry]

We are having the same issue with Word 2007 not bringing the Excel formatting
we have set in the Excel file.

While we can do the steps you recommend, we did not have this issue with
Word 2003. Are we missing something or did Word 2007 take a step backwards?

We hope you or some of the Microsoft gurus will reply.

Thanks.

 

[Suzanne S. Barnhill]

Actually, this changed in Word 2002, when MS changed the connection method
from DDE to OLEDB, but you can still use DDE; see
http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm.