Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge from Access - incorrect date/time format
Hi Dawn,
If you select the mergefields and press Shift-F9, you should see something like {MERGEFIELD MyDate} and {MERGEFIELD MyTime}. To get the date format you want, you can add a formatting picture switch. For example if you add '\@ "ddd, d MMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "dddd, d MMM yyyy"} your date will come out as 'Saturday, 2 August 2008'. You probably want {MERGEFIELD MyDate \@ "d/MM/yy"}. Similarly, if you format the time mergefield as {MERGEFIELD MyTime \@ "HH:mmAM/PM"} you should get the results you're after. -- Cheers macropod [MVP - Microsoft Word] "dawnjlane" wrote in message ... Hi Everyone I am having problems with mail merge between Access and Word with date and time formats changing. I use Office 2007 and the date in Access is set to short date ie 02/08/08 and time also to short time ie 12:00PM. When I do a mail merge into a Word template the dates are transposing into American long date ie 08/02/2008 and time as 12:00:00 PM. I have checked the date and time settings in Access, Word and on the computer itself and all are set to UK English. I am presently having to do a find and replace for all the entries which is quite tiresome as there are 3 x different date entries and 1 time entry. Any one come across this before and how did you solve it? Dawn -- dawnjlane |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge from Access - incorrect date/time format
Hi Everyone I am having problems with mail merge between Access and Word with date and time formats changing. I use Office 2007 and the date in Access is set to short date ie 02/08/08 and time also to short time ie 12:00PM. When I do a mail merge into a Word template the dates are transposing into American long date ie 08/02/2008 and time as 12:00:00 PM. I have checked the date and time settings in Access, Word and on the computer itself and all are set to UK English. I am presently having to do a find and replace for all the entries which is quite tiresome as there are 3 x different date entries and 1 time entry. Any one come across this before and how did you solve it? Dawn -- dawnjlane |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge from Access - incorrect date/time format
If that doesn't work, use the Format() function in a Query in Access to
convert the date to text in the format that you want it. -- 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 "macropod" wrote in message ... Hi Dawn, If you select the mergefields and press Shift-F9, you should see something like {MERGEFIELD MyDate} and {MERGEFIELD MyTime}. To get the date format you want, you can add a formatting picture switch. For example if you add '\@ "ddd, d MMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "dddd, d MMM yyyy"} your date will come out as 'Saturday, 2 August 2008'. You probably want {MERGEFIELD MyDate \@ "d/MM/yy"}. Similarly, if you format the time mergefield as {MERGEFIELD MyTime \@ "HH:mmAM/PM"} you should get the results you're after. -- Cheers macropod [MVP - Microsoft Word] "dawnjlane" wrote in message ... Hi Everyone I am having problems with mail merge between Access and Word with date and time formats changing. I use Office 2007 and the date in Access is set to short date ie 02/08/08 and time also to short time ie 12:00PM. When I do a mail merge into a Word template the dates are transposing into American long date ie 08/02/2008 and time as 12:00:00 PM. I have checked the date and time settings in Access, Word and on the computer itself and all are set to UK English. I am presently having to do a find and replace for all the entries which is quite tiresome as there are 3 x different date entries and 1 time entry. Any one come across this before and how did you solve it? Dawn -- dawnjlane |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge from Access - incorrect date/time format
Thanks - worked a treat. Dawn -- dawnjlane[/i][/color] [/i][/color] -- dawnjlane |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access Query to mailmerge US Date | Mailmerge | |||
Format Date and Time to show Military Time | Microsoft Word Help | |||
Date and time format | Microsoft Word Help | |||
Inserting date/time in certain format? | New Users | |||
incorrect date format in mail merge | Mailmerge |