How do I format a birthdate for mail merge labels GPCHS 10/3/2008 6:10:07 PM 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?

Re: How do I format a birthdate for mail merge labels "macropod" <macropod[ at ]invalid.invalid> 10/4/2008 2:04:22 AM 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 \[ at ] "DD-MM-YY"} .. Run your mailmerge -- Cheers macropod [MVP - Microsoft Word] "GPCHS" <GPCHS[ at ]discussions.microsoft.com> wrote in message news:51ED9CD3-B3B1-4387-AC4B-7638C52027BA[ at ]microsoft.com... [Quoted Text] >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?

Re: How do I format a birthdate for mail merge labels "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/4/2008 8:40:00 AM 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 "GPCHS" <GPCHS[ at ]discussions.microsoft.com> wrote in message news:51ED9CD3-B3B1-4387-AC4B-7638C52027BA[ at ]microsoft.com... [Quoted Text] >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?