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