Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help correcting Date Format
I think I've screwed up my letter trying to fix this. I have merged
information from my database, but the date comes up as 11/29/2007 instead of November 29, 2007. I've tried to correct his, but then all I get in my merged letter is DATE. I've seen multiple format options, but I can't figure out how to fix this. Any help is appreciated. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help correcting Date Format
Jon wrote:
I think I've screwed up my letter trying to fix this. I have merged information from my database, but the date comes up as 11/29/2007 instead of November 29, 2007. I've tried to correct his, but then all I get in my merged letter is DATE. I've seen multiple format options, but I can't figure out how to fix this. Any help is appreciated. Change (or add) the formatting switch to the fiield {Mergefield DATE \@ "MMMM d, yyyy"} 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help correcting Date Format
There may be an answer somewhere on that web page, but it eludes me.
"Graham Mayor" wrote: Jon wrote: I think I've screwed up my letter trying to fix this. I have merged information from my database, but the date comes up as 11/29/2007 instead of November 29, 2007. I've tried to correct his, but then all I get in my merged letter is DATE. I've seen multiple format options, but I can't figure out how to fix this. Any help is appreciated. Change (or add) the formatting switch to the fiield {Mergefield DATE \@ "MMMM d, yyyy"} 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help correcting Date Format
When I attempt to fix the format and then do a merge instead of getting any
date I get: {DATE \@ "MMMMd,YYYY"} "Jon" wrote: There may be an answer somewhere on that web page, but it eludes me. "Graham Mayor" wrote: Jon wrote: I think I've screwed up my letter trying to fix this. I have merged information from my database, but the date comes up as 11/29/2007 instead of November 29, 2007. I've tried to correct his, but then all I get in my merged letter is DATE. I've seen multiple format options, but I can't figure out how to fix this. Any help is appreciated. Change (or add) the formatting switch to the fiield {Mergefield DATE \@ "MMMM d, yyyy"} 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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help correcting Date Format
Assuming that DATE is the name of the field in the data source, what you
need is { MERGEFIELD DATE \@ "MMMM dd, yyyy" } Starting the the Merge Field already in the document, pressing Alt + F9 to reveal the field codes should result in the following being displayed { MERGEFIELD DATE } The you would add the formatting switch inside the closing field delimiter } Starting from scratch, you must use Ctrl+F9 to insert the field delimiters and you use Alt+F9 to toggle off their display. -- 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 "Jon" wrote in message ... When I attempt to fix the format and then do a merge instead of getting any date I get: {DATE \@ "MMMMd,YYYY"} "Jon" wrote: There may be an answer somewhere on that web page, but it eludes me. "Graham Mayor" wrote: Jon wrote: I think I've screwed up my letter trying to fix this. I have merged information from my database, but the date comes up as 11/29/2007 instead of November 29, 2007. I've tried to correct his, but then all I get in my merged letter is DATE. I've seen multiple format options, but I can't figure out how to fix this. Any help is appreciated. Change (or add) the formatting switch to the fiield {Mergefield DATE \@ "MMMM d, yyyy"} 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 |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help correcting Date Format
The answer was in my reply. The page is a reference on the use of switches
generally. If instead of a Merge date field you are simply using a date field then the field should be modified to {DATE \@ "MMMM d, yyyy"} If your merge is showing that then either you have not used CTRL+F9 for the field brackets and thus your field is merely text, or you need to set tools options print uncheck 'Field Codes'. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jon wrote: There may be an answer somewhere on that web page, but it eludes me. "Graham Mayor" wrote: Jon wrote: I think I've screwed up my letter trying to fix this. I have merged information from my database, but the date comes up as 11/29/2007 instead of November 29, 2007. I've tried to correct his, but then all I get in my merged letter is DATE. I've seen multiple format options, but I can't figure out how to fix this. Any help is appreciated. Change (or add) the formatting switch to the fiield {Mergefield DATE \@ "MMMM d, yyyy"} 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 |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help correcting Date Format
Thanks to both...not quite sure how I got it, but it's working.
"Graham Mayor" wrote: The answer was in my reply. The page is a reference on the use of switches generally. If instead of a Merge date field you are simply using a date field then the field should be modified to {DATE \@ "MMMM d, yyyy"} If your merge is showing that then either you have not used CTRL+F9 for the field brackets and thus your field is merely text, or you need to set tools options print uncheck 'Field Codes'. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jon wrote: There may be an answer somewhere on that web page, but it eludes me. "Graham Mayor" wrote: Jon wrote: I think I've screwed up my letter trying to fix this. I have merged information from my database, but the date comes up as 11/29/2007 instead of November 29, 2007. I've tried to correct his, but then all I get in my merged letter is DATE. I've seen multiple format options, but I can't figure out how to fix this. Any help is appreciated. Change (or add) the formatting switch to the fiield {Mergefield DATE \@ "MMMM d, yyyy"} 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change date format for Comments and display date in balloons | Microsoft Word Help | |||
How do I change the date format to a long date after merging it | Mailmerge | |||
I am trying to format the date returned by a custom date property | Microsoft Word Help | |||
How can I add a format to the "Insert Date" format gallery? | Microsoft Word Help | |||
Date issue merging from Excel field in Date format to Word | Mailmerge |