View Single Post
  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jon jon is offline
external usenet poster
 
Posts: 66
Default 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