Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail merge query re date formatting
I am using Excel as the source document for a mail merge in Word. This
includes dates, but when merged they always appear in the American format of month, date then year. How do I get these in the European format of day, month & year. I have tried reformatting the source document to no avail. This did not happen in earlier versions of Word. (Using 2003 version) |
#2
|
|||
|
|||
Hi ?B?eXZvbm5lcGF0ZXJzb25Ac291bmRjb250cm9sLmNvLnVr?= ,
I am using Excel as the source document for a mail merge in Word. This includes dates, but when merged they always appear in the American format of month, date then year. How do I get these in the European format of day, month & year. I have tried reformatting the source document to no avail. This did not happen in earlier versions of Word. (Using 2003 version) You'll find information on this in the Word 2002/2003 section of my website's mail merge FAQ. Basically, you need to either use the previous data connection technology or add formatting switches to the merge fields. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I set up a query for my mail merge | Mailmerge | |||
How to remove unwanted formatting in mail merge for cells witn no | Mailmerge | |||
English/American date formatting in XP mail merge | Mailmerge | |||
mail merge and access query | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |