Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
The date in a merged word doc is US format source is UK format
I have created an access database with date fields in the UK format
dd/mm/yyyy. When I merge this data into a word document the date field is shown in the US format mm/dd/yyyy. The regional settings are for the UK. Please advise a solution. Thank you |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
The date in a merged word doc is US format source is UK format
Hi Cogito,
You can fix this by adding a switch to the mergefield. To do this: .. select the field and press Shift-F9. You should see something like {MERGEFIELD dbDate} .. change this to {MERGEFIELD dbDate \@ DD/MM/YYYY} .. press F9 to update the field .. run your mailmerge For more information on field formatting, see Word's help file Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Cogito" wrote in message ... I have created an access database with date fields in the UK format dd/mm/yyyy. When I merge this data into a word document the date field is shown in the US format mm/dd/yyyy. The regional settings are for the UK. Please advise a solution. Thank you |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
The date in a merged word doc is US format source is UK forma
Macropod
Thank you for your reply. This solution worked. I am suprised that on a UK spec pc. Is there a permanent fix? Regards "macropod" wrote: Hi Cogito, You can fix this by adding a switch to the mergefield. To do this: .. select the field and press Shift-F9. You should see something like {MERGEFIELD dbDate} .. change this to {MERGEFIELD dbDate \@ DD/MM/YYYY} .. press F9 to update the field .. run your mailmerge For more information on field formatting, see Word's help file Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Cogito" wrote in message ... I have created an access database with date fields in the UK format dd/mm/yyyy. When I merge this data into a word document the date field is shown in the US format mm/dd/yyyy. The regional settings are for the UK. Please advise a solution. Thank you |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
The date in a merged word doc is US format source is UK forma
That is the permanent fix. Word reads the raw data stored in Excel - See
also From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. (In Word 2007 it is Office Button Word Options Advanced General Confirm file format conversion on open). Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Cogito wrote: Macropod Thank you for your reply. This solution worked. I am suprised that on a UK spec pc. Is there a permanent fix? Regards "macropod" wrote: Hi Cogito, You can fix this by adding a switch to the mergefield. To do this: .. select the field and press Shift-F9. You should see something like {MERGEFIELD dbDate} .. change this to {MERGEFIELD dbDate \@ DD/MM/YYYY} .. press F9 to update the field .. run your mailmerge For more information on field formatting, see Word's help file Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Cogito" wrote in message ... I have created an access database with date fields in the UK format dd/mm/yyyy. When I merge this data into a word document the date field is shown in the US format mm/dd/yyyy. The regional settings are for the UK. Please advise a solution. Thank you |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
The date in a merged word doc is US format source is UK forma
Graham
Thank you for your reply. Excellent "Graham Mayor" wrote: That is the permanent fix. Word reads the raw data stored in Excel - See also From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. (In Word 2007 it is Office Button Word Options Advanced General Confirm file format conversion on open). Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Cogito wrote: Macropod Thank you for your reply. This solution worked. I am suprised that on a UK spec pc. Is there a permanent fix? Regards "macropod" wrote: Hi Cogito, You can fix this by adding a switch to the mergefield. To do this: .. select the field and press Shift-F9. You should see something like {MERGEFIELD dbDate} .. change this to {MERGEFIELD dbDate \@ DD/MM/YYYY} .. press F9 to update the field .. run your mailmerge For more information on field formatting, see Word's help file Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Cogito" wrote in message ... I have created an access database with date fields in the UK format dd/mm/yyyy. When I merge this data into a word document the date field is shown in the US format mm/dd/yyyy. The regional settings are for the UK. Please advise a solution. Thank you |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merged Date format switches not working in Word 2003 | Mailmerge | |||
how to keep date format in merged document same as in data source | Microsoft Word Help | |||
word changes merged access data 'date' format from d/m/y to m/d/y | Mailmerge | |||
date uk format from merged access query | Microsoft Word Help | |||
Mailmerge in Word, date format in merged doc | Mailmerge |