Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format a birthdate for mail merge labels
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format a birthdate for mail merge labels
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 -- Cheers macropod [MVP - Microsoft Word] "GPCHS" wrote in message ... 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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format a birthdate for mail merge labels
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/cindy...r/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" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to vertical format in mail merge labels? | Mailmerge | |||
Mail merge Labels Excel to Word - Need Help with format of numbers | Mailmerge | |||
Mail merge to continuous labels skips labels between pages | Mailmerge | |||
Format of Mail Merge Labels | Mailmerge | |||
Word Labels into Mail Merge Labels | Mailmerge |