Mail Merge Problem

[Guest]

I am working on a mail merge from an Access query, and I am trying to
reformat one of the date feilds that is in the numerical format. I want the
date to be written out (January 17th, 1997) rather than the numerical
(1/17/1997). The original feild in the query is in the numerical. How do I
get word to re-format the feild to a written out format?

Thanks in advance

 

[Cindy M.]

Hi =?Utf-8?B?V2lsbGlhbTUyNzE=?=,

I am working on a mail merge from an Access query, and I am trying to
reformat one of the date feilds that is in the numerical format. I want the
date to be written out (January 17th, 1997) rather than the numerical
(1/17/1997). The original feild in the query is in the numerical. How do I
get word to re-format the feild to a written out format?

Well, the Word-centric way is to add a formatting switch to the field code.
For example:

{ Mergefield MyDateField \@ "MMMM d, yyyy" }

(Note that you can't get the "th" with a single field switch. You'd have to
break it down into multiple fields, one for each part of the date. Then you
should be able to use the \* Ordinal switch for the day of the month.)

The Access-centric approach, which is something to consider if you need this
information more than once, is to create a query. Specify the number format as
part of the query.

In an empty column of the query design grid, something like this:

MergeDate: Format(MyDateField, "MMMM d, yyyy")

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Guest]

Will this also work if your data is coming from an excel file?
Thanks,
Denise

 

[Graham Mayor]

The field switch will work - see
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>