Importing dates from Excel to Word 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ptnana - 12 Jul 2007 00:20 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 12 Jul 2007 03:00 GMT

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

Signature

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

> My database is Excel 2007. I have names, addresses and dates. When I try
> to
[quoted text clipped - 4 lines]
>
> Annette

Reply to this Message

ptnana - 12 Jul 2007 06:00 GMT

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

> While Excel may display the date in that format, it does not store it in
> that format.
[quoted text clipped - 12 lines]
> >
> > Annette

Reply to this Message

ptnana - 12 Jul 2007 06:38 GMT

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.

> While Excel may display the date in that format, it does not store it in
> that format.
[quoted text clipped - 12 lines]
> >
> > Annette

Reply to this Message

Graham Mayor - 12 Jul 2007 06:49 GMT

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

Signature

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

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

> 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.
[quoted text clipped - 40 lines]
>>>
>>> Annette

Reply to this Message

ptnana - 12 Jul 2007 21:50 GMT

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

> Change {MERGEFIELD "Date"}
> to read
[quoted text clipped - 44 lines]
> >>>
> >>> Annette

Reply to this Message

Graham Mayor - 13 Jul 2007 06:40 GMT

You are welcome :)

Signature

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

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

> THANK YOU, THANK YOU, THANK YOU. It works fine now.
>
[quoted text clipped - 54 lines]
>>>>>
>>>>> Annette

Reply to this Message

Rate this thread: