Date Format and Merger

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Antonio - 30 May 2008 17:56 GMT

When doing a mail merge and trying to import dates from the recepient list
(an excell document) to a word document, all dates appear on US format, even
though all my language and regional settings are for Ireland. Does anybody
have a solution for this, please? Thank you

Reply to this Message

Cindy M. - 31 May 2008 12:12 GMT

Hi Antonio,

> When doing a mail merge and trying to import dates from the recepient list
> (an excell document) to a word document, all dates appear on US format, even
> though all my language and regional settings are for Ireland.

You need to edit the field codes. Press Alt+F9 in the main merge document.
Locate the merge fields containing date information and add a formatting
switch. For example:

{Mergefield MyDate \@ "d-MMM-yyyy" }

Would give a result like: 31-May-2008

Alt+F9 again to hide the field codes.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message