I have tried several times to try to figure out how to do this and cannot.
here is the information and example of what is needed.
The excel program looks like this:
Column "A" Column "B"
Date Name
November 12, 2006 Bobbie Rhone
November 12, 2006 Damiais Harris
November 18, 2006 Amalia Rios
November 23, 2006 Julia Jones
The Word Program should read:
Regarding your visit on November 12, 2006.
I am currently using {MERGEFIELD "Date"}
Trying to use any of the other instructions given me does not work.
Evidently I am doing something wrong. Please advise.
"Doug Robbins - Word MVP" wrote:
While Excel may display the date in that format, it does not store it in
that format.
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.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
"ptnana" wrote in message
...
My database is Excel 2007. I have names, addresses and dates. When I try
to
mail merge the dates to my Word program, the dates come out as 6/8/07
instead
of June 8, 2007. What settings do I need to plug in on either program to
correct this? I have my Excel program column set to date: March 1, 2007.
Annette