mail merge 2007 word labels

G

GPCHS

I have exported a list from our student program to excel for a label mail
merge. I have their birthdates in the list. When I merge and update the
labels the birthdate format changes to mm-dd-yyyy. I can not get it to change
to yyyy-mm-dd. any suggestions. I have tried to format the cells in excel as
a date in the y-m-d format but it still goes to word as mm-dd-yyyy.? Please
and Thank you!!!!
 
D

Doug Robbins - Word MVP

Press Alt+F9 in the mail merge main document to toggle on the display of the
field codes and inside the closing } of the mergefield in question, add the
following formatting switch:

\@ "yyyy-MM-dd"

If that 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top