When mailmerging Date of Birth it automatically defaults to US for

[Hannab2005]

How do I stop my mail merge from automatically changing any dates of birth to
the US format (11/26/85 instead of 26/11/85) Please help!

Hannah

 

[Graham Mayor]

Use a formatting switch - http://www.gmayor.com/formatting_word_fields.htm

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


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

 

[hannab2005]

Ok to me it is all gibberish, Is there a simple way of setting this up? I am
not a programmer, all the information provided unfortunatly did not help me
as I did not understand what needed to be done. Thank you anyway.

 

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Graham Mayor]

With your cusror in the offending field, right click and toggle field codes.
The field will change from something like
<<mydate>> to {Mergefield Mydate}
Before the final bracket add the switch eg

{Mergefield Mydate \@ "dd/MM/yy"}
With the cursor still in the field, press F9 and the field will update and
revert to the previous display and your date should be corrected.

This is not programming nor rocket science, but the basic tools of mail
merge.

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


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

 

[hannab2005]

Thank you very much, I will definitely be using this often enough!