Formatting of merged fields for date and times doesn't work with E

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RJR - 18 Feb 2007 15:01 GMT

Hello,

I have a several WORD merge files that use Excel as my data source. I have
the following merge fields in the body of the letter.

". I will meet you at your establishment on 39142 at 0.53125. Please have the
following information available for my review:"

I have used alt-F9 and the merge field looks like this. { MERGEFIELD
"L01_Visit_Date"\@ "Dddd, Mmmm dd, yyyy" } and {MERGEFIELD
"L01_Visit_Time"\@ "hh:mm am/pm"}.

Is thjere something that I'm missing to get the format correct?

This same problem is apparant with all my merge documents. How can I make
these display correctly.

Any help is appreciated.

I am using a macro in Excell to do the opening and finding of the database,
BUT the behavior is the same with or without the code opening or closing the
case. The particular field in EXCEL 2003 is formatted as date and hour and
they work fine in EXCEL.

Would making that field a "Text" field work, or would that just bring the
numbers over too.

Thanks in advance.

Bob Reynolds

Reply to this Message

Graham Mayor - 18 Feb 2007 15:36 GMT

It seems that Word doesn't recognize the Excel information as a date to be
formatted, any more than I recognize your date switch.
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should read the
data as you have it formatted in the table without the switch.
See http://www.gmayor.com/formatting_word_fields.htm for details of date
switches.

Signature

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

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

> Hello,
>
[quoted text clipped - 26 lines]
>
> Bob Reynolds

Reply to this Message

RJR - 18 Feb 2007 20:04 GMT

Thank you Graham. I got that switch from the board here when I asked how to
format a date to read Saturday, February 21, 2006. I made it in the custom
selection and it's worked great for me so far.

> It seems that Word doesn't recognize the Excel information as a date to be
> formatted, any more than I recognize your date switch.
[quoted text clipped - 36 lines]
> >
> > Bob Reynolds

Reply to this Message

Graham Mayor - 19 Feb 2007 06:41 GMT

The switch for
Monday, February 19, 2007

would be - \@ "dddd, MMMM d, yyyy"
your switch \@ "Dddd, Mmmm dd, yyyy"
produces 19Mon, 23838 19, 2007 ?

Signature

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

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

> Thank you Graham. I got that switch from the board here when I asked
> how to format a date to read Saturday, February 21, 2006. I made it
[quoted text clipped - 49 lines]
>>>
>>> Bob Reynolds

Reply to this Message