How do I format a birthdate for mail merge labels

[GPCHS]

I am creating labels for student files. I have my list exported to Excel.
When I do a mail merge the Birthdate set at YY-MM-DD in excel - changes to
DD-MM-YY on the label. How do I correct this on the label?

 

[macropod]

Hi GPCHS,

To fix this:
.. Select the problem mergefield and press Shift-F9. You should see something like {MERGEFIELD Birthdate}
.. Add a date switch to the field, so that you end up with {MERGEFIELD Birthdate \@ "DD-MM-YY"}
.. Run your mailmerge

 

[Doug Robbins - Word MVP]

If adding the formatting switch as macropod suggests does not overcome the
problem, See the "Dates: day/month reversed" item under the "Connection
methods" topic of the "Mail merge in Word 2002/2003" 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