Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
ward merg - date
Hello,
The date is 06/01/2009 in the datatable (access) but in the merge letter it is exhibit as 01/06/2009. way, what shold i do ? thank you -- תודה רבה |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
ward merg - date
Hi yarivr,
To get the date format you want, you can add a formatting picture switch. In Word: .. select the mergefield; .. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's name; .. delete anything appearing after the mergefield's name and add '\@ "d MMMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM yyyy"}. With this switch your date will come out as '2 August 2008'. Other possible date formatting switches include: . \@ "dddd, d MMMM yyyy"; . \@ "ddd, d MMMM yyyy"; . \@ "d MMM yyyy"; . \@ "dd/MMM/yyyy"; . \@ "d-MM-yy"; Note: you must use uppercase 'M's for months. .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The above assumes an english-language installation of Word - I don't know whether the day, month & year designations for other languages is the same. -- Cheers macropod [MVP - Microsoft Word] "יריב החביב" wrote in message ... Hello, The date is 06/01/2009 in the datatable (access) but in the merge letter it is exhibit as 01/06/2009. way, what shold i do ? thank you -- תודה רבה |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
ward merg - date
thank's
-- תודה רבה "macropod" wrote: Hi yarivr, To get the date format you want, you can add a formatting picture switch. In Word: .. select the mergefield; .. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's name; .. delete anything appearing after the mergefield's name and add '\@ "d MMMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM yyyy"}. With this switch your date will come out as '2 August 2008'. Other possible date formatting switches include: . \@ "dddd, d MMMM yyyy"; . \@ "ddd, d MMMM yyyy"; . \@ "d MMM yyyy"; . \@ "dd/MMM/yyyy"; . \@ "d-MM-yy"; Note: you must use uppercase 'M's for months. .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The above assumes an english-language installation of Word - I don't know whether the day, month & year designations for other languages is the same. -- Cheers macropod [MVP - Microsoft Word] "יריב החביב" wrote in message ... Hello, The date is 06/01/2009 in the datatable (access) but in the merge letter it is exhibit as 01/06/2009. way, what shold i do ? thank you -- תודה רבה |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set AutoText in Ward 2007 | Microsoft Word Help | |||
Word E-Mail Merg | Mailmerge | |||
how can i translate a ward? | Microsoft Word Help | |||
mail merg | Mailmerge | |||
ward was unable to complete save due to file permission error | Microsoft Word Help |