Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date format switches
Hopefully someone can solve this problem.
I have used the date switch to swap from US date format to non-US date format in a word doc and it worked great. When I come to use the same switch in another word doc it doesn't work. The only thing I have changed is the field name, and yes, I have typed it in correctly, it was the first thing I checked! :-) This is the code I've put in { MERGEFIELD Date_Received @\ "dd/MM/yy" } I wondered at first if it had something to do with the space or "_" in the field name but the field name in the switch that works also has a space. Basically I am totally stumped!! Can anyone shed any light on this? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date format switches
The correct syntax is
{ MERGEFIELD Date_Received \@ "dd/MM/yy" } see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote Hopefully someone can solve this problem. I have used the date switch to swap from US date format to non-US date format in a word doc and it worked great. When I come to use the same switch in another word doc it doesn't work. The only thing I have changed is the field name, and yes, I have typed it in correctly, it was the first thing I checked! :-) This is the code I've put in { MERGEFIELD Date_Received @\ "dd/MM/yy" } I wondered at first if it had something to do with the space or "_" in the field name but the field name in the switch that works also has a space. Basically I am totally stumped!! Can anyone shed any light on this? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date format switches
Hi
Thanks for the reply, silly me typed the syntax in the comment incorrectly, however, the syntax in the switch is correct and it still won't work! "Graham Mayor" wrote: The correct syntax is { MERGEFIELD Date_Received \@ "dd/MM/yy" } see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote Hopefully someone can solve this problem. I have used the date switch to swap from US date format to non-US date format in a word doc and it worked great. When I come to use the same switch in another word doc it doesn't work. The only thing I have changed is the field name, and yes, I have typed it in correctly, it was the first thing I checked! :-) This is the code I've put in { MERGEFIELD Date_Received @\ "dd/MM/yy" } I wondered at first if it had something to do with the space or "_" in the field name but the field name in the switch that works also has a space. Basically I am totally stumped!! Can anyone shed any light on this? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date format switches
What do you mean by 'won't work'? Have you updated the field?
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote: Hi Thanks for the reply, silly me typed the syntax in the comment incorrectly, however, the syntax in the switch is correct and it still won't work! "Graham Mayor" wrote: The correct syntax is { MERGEFIELD Date_Received \@ "dd/MM/yy" } see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote Hopefully someone can solve this problem. I have used the date switch to swap from US date format to non-US date format in a word doc and it worked great. When I come to use the same switch in another word doc it doesn't work. The only thing I have changed is the field name, and yes, I have typed it in correctly, it was the first thing I checked! :-) This is the code I've put in { MERGEFIELD Date_Received @\ "dd/MM/yy" } I wondered at first if it had something to do with the space or "_" in the field name but the field name in the switch that works also has a space. Basically I am totally stumped!! Can anyone shed any light on this? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date format switches
Hi
This is what I have done to try to get it to work Right clicked and selected update field Reconnected to the correct query from Access Merged data to a new document Repeatedly clicked the "View Merged Data" button Made sure that the field format in Access is short date Closed down both Word and Access, opened up Access again and opened the word file using the access hyperlink Really starting to question my sanity now! Cheers Sara "Graham Mayor" wrote: What do you mean by 'won't work'? Have you updated the field? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote: Hi Thanks for the reply, silly me typed the syntax in the comment incorrectly, however, the syntax in the switch is correct and it still won't work! "Graham Mayor" wrote: The correct syntax is { MERGEFIELD Date_Received \@ "dd/MM/yy" } see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote Hopefully someone can solve this problem. I have used the date switch to swap from US date format to non-US date format in a word doc and it worked great. When I come to use the same switch in another word doc it doesn't work. The only thing I have changed is the field name, and yes, I have typed it in correctly, it was the first thing I checked! :-) This is the code I've put in { MERGEFIELD Date_Received @\ "dd/MM/yy" } I wondered at first if it had something to do with the space or "_" in the field name but the field name in the switch that works also has a space. Basically I am totally stumped!! Can anyone shed any light on this? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date format switches
See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at : http://homepage.swissonline.ch/cindy...r/MergFram.htm -- 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 "Sara Lindley" wrote in message ... Hi This is what I have done to try to get it to work Right clicked and selected update field Reconnected to the correct query from Access Merged data to a new document Repeatedly clicked the "View Merged Data" button Made sure that the field format in Access is short date Closed down both Word and Access, opened up Access again and opened the word file using the access hyperlink Really starting to question my sanity now! Cheers Sara "Graham Mayor" wrote: What do you mean by 'won't work'? Have you updated the field? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote: Hi Thanks for the reply, silly me typed the syntax in the comment incorrectly, however, the syntax in the switch is correct and it still won't work! "Graham Mayor" wrote: The correct syntax is { MERGEFIELD Date_Received \@ "dd/MM/yy" } see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote Hopefully someone can solve this problem. I have used the date switch to swap from US date format to non-US date format in a word doc and it worked great. When I come to use the same switch in another word doc it doesn't work. The only thing I have changed is the field name, and yes, I have typed it in correctly, it was the first thing I checked! :-) This is the code I've put in { MERGEFIELD Date_Received @\ "dd/MM/yy" } I wondered at first if it had something to do with the space or "_" in the field name but the field name in the switch that works also has a space. Basically I am totally stumped!! Can anyone shed any light on this? |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date format switches
Thanks Doug
After looking around via the link you gave me I found something different to try and hey presto! after changing the database connection method to "MS Access Database via ODBC" the date switch works! Thanks to Graham as well for taking the time to try and solve this for me. "Doug Robbins - Word MVP" wrote: See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at : http://homepage.swissonline.ch/cindy...r/MergFram.htm -- 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 "Sara Lindley" wrote in message ... Hi This is what I have done to try to get it to work Right clicked and selected update field Reconnected to the correct query from Access Merged data to a new document Repeatedly clicked the "View Merged Data" button Made sure that the field format in Access is short date Closed down both Word and Access, opened up Access again and opened the word file using the access hyperlink Really starting to question my sanity now! Cheers Sara "Graham Mayor" wrote: What do you mean by 'won't work'? Have you updated the field? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote: Hi Thanks for the reply, silly me typed the syntax in the comment incorrectly, however, the syntax in the switch is correct and it still won't work! "Graham Mayor" wrote: The correct syntax is { MERGEFIELD Date_Received \@ "dd/MM/yy" } see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sara Lindley wrote Hopefully someone can solve this problem. I have used the date switch to swap from US date format to non-US date format in a word doc and it worked great. When I come to use the same switch in another word doc it doesn't work. The only thing I have changed is the field name, and yes, I have typed it in correctly, it was the first thing I checked! :-) This is the code I've put in { MERGEFIELD Date_Received @\ "dd/MM/yy" } I wondered at first if it had something to do with the space or "_" in the field name but the field name in the switch that works also has a space. Basically I am totally stumped!! Can anyone shed any light on this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to suppress autotext US date format after typing current year | Microsoft Word Help | |||
Mailmerge date format | Mailmerge | |||
How can I add a format to the "Insert Date" format gallery? | Microsoft Word Help | |||
How do I get UK date format merging into word from Access? | Mailmerge | |||
date format change when using serial printing | Microsoft Word Help |