Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
wrong date display in mail merge
Hello all,
I'm using XP, Access 2000 and word 2000. I have set up a simple databse and mail merge letter. All the merge fields work fine except InsolvencyDate. It is required that the date display in the mail merge letter as dd/mmm/yy, but it displays as the american version, mm/dd/yyyy. I have checked regional settings and have also set the format and input mask, both in the databsae table and data entry form, but no change in the letter display. Any ideas anyone? The letter is useless to my job the way it is. Thanks in advance |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
wrong date display in mail merge
Use Alt-F9 to display the "underlying field code" of your field, which
should look something like { MERGEFIELD "InsolvencyDate" } or { MERGEFIELD "InsolvencyDate" \*Mergeformat } then type a "date format switch" into the field so that it looks like { MERGEFIELD "InsolvencyDate" \@"DD/MM/YYYY" } or { MERGEFIELD "InsolvencyDate" \@"DD/MM/YYYY" \*Mergeformat } Make sure you use upper case MM and not lower case mm (which means "minutes") Click Alt-F9 again Select the MERGEFIELD field and press F9 Try the merge again. If that doesn't fix the problem, you'll need to create a new query in Access to return the right result. But let's see if that is necessary first. Peter Jamieson "Gadget" wrote in message ... Hello all, I'm using XP, Access 2000 and word 2000. I have set up a simple databse and mail merge letter. All the merge fields work fine except InsolvencyDate. It is required that the date display in the mail merge letter as dd/mmm/yy, but it displays as the american version, mm/dd/yyyy. I have checked regional settings and have also set the format and input mask, both in the databsae table and data entry form, but no change in the letter display. Any ideas anyone? The letter is useless to my job the way it is. Thanks in advance |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Previews Wrong | Mailmerge | |||
mail merge putting fields in the wrong place! | Mailmerge | |||
Mail merge data comes in wrong size font Why? | Mailmerge | |||
Wrong mail merge date format | Mailmerge | |||
Mail merge is using the wrong data base. Help. | Mailmerge |