[ptnana]

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

[Doug Robbins - Word MVP]

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

[ptnana]

Totally confusing. I will try it and let you know what happens. Thank you.

"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

[ptnana]

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

[Graham Mayor]

Change {MERGEFIELD "Date"}
to read
{MERGEFIELD "Date" \@ "MMMM d, yyyy" }
then update the field - F9
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ptnana wrote:
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
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

[ptnana]

THANK YOU, THANK YOU, THANK YOU. It works fine now.

"Graham Mayor" wrote:

Change {MERGEFIELD "Date"}
to read
{MERGEFIELD "Date" \@ "MMMM d, yyyy" }
then update the field - F9
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ptnana wrote:
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
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

[Graham Mayor]

You are welcome

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



ptnana wrote:
THANK YOU, THANK YOU, THANK YOU. It works fine now.

"Graham Mayor" wrote:

Change {MERGEFIELD "Date"}
to read
{MERGEFIELD "Date" \@ "MMMM d, yyyy" }
then update the field - F9
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


ptnana wrote:
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
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