Excel XP to Word XP mail merge: date formats (again!)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alasdair - 08 Jan 2004 20:22 GMT

Hello.

I've had a look at Cindy Meister's and Graham Mayor's pages, but don't see
this particular issue discussed....

I have an Excel spreadsheet with all dates in the format dd/mm/yy. When I
merge into a word document all the dates are displayed as dd/mm/yy. So far,
so good!

HOWEVER, in the 'Mail Merge Recipients' window as I'm filtering the data,
the date fields appear as mm/dd/yy. Also, any blank fields appear as
'12:00:00 AM'. Is there anyway of making this appear as dd/mm/yy?

It's not a showstopper, but it would help my staff who are doing the
mailmerge if it was consistently dd/mm/yy.

Thanks

Alasdair

Reply to this Message

Graham Mayor - 09 Jan 2004 08:50 GMT

See http://support.microsoft.com/default.aspx?kbid=327579

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hello.
>
[quoted text clipped - 16 lines]
>
> Alasdair

Reply to this Message

Peter Jamieson - 09 Jan 2004 09:05 GMT

I'd be interested to know whether or not you asked for the hotfix described
in

http://support.microsoft.com/default.aspx?kbid=327579

and if so, whether it makes any difference to the display in the Recipients
dialog.

Otherwise, I think the only options are
a. use the Converter to connect (you should see the dates exactly as you
want in the Recients dialog)
b. use ODBC to connect (you should see the correct date format but with a
following 00:00:00 time, and blank dates should be blank)
c. Use MS Query to connect and write queries that convert dates to texts.
(I haven't tried it as IMO it's overkill in this situation even if it
works).

Trouble is that whenever you change the connection method it tends to
introduce other formatting or operational issues.

--
Peter Jamieson - Word MVP
Word MVP web site http://www.mvps.org/word

> Hello.
>
[quoted text clipped - 15 lines]
>
> Alasdair

Reply to this Message