How do I stop Mail Merge from changing dates to USA format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan Wachowski - 25 Sep 2006 05:09 GMT

I have Excel & Word 2003.

I have created an Excel database with dates stored in Australian format ie
DD/MMM/YY

When I merge this into a word document it converts the dates to USA format
ie MM/DD/YY.

How do I stop this from occuring?

Reply to this Message

Graham Mayor - 25 Sep 2006 06:08 GMT

Use a date switch on your date field -
http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> I have Excel & Word 2003.
>
[quoted text clipped - 5 lines]
>
> How do I stop this from occuring?

Reply to this Message

vetondenet - 26 Sep 2006 04:27 GMT

Hi
I'm almost computer illiterate so didn't understand a word of Graham's site
(Thanks anyway Graham!) Anyway, my brother got me around the problem of
Americans and their rubbish inability to do things properly like the rest of
the world.. Copy the Excel sheet into word and then use that as your file for
importing into the mail merge. It doesn't solve the problem but it does
bypass it.

Signature

vetondenet

> I have Excel & Word 2003.
>
[quoted text clipped - 5 lines]
>
> How do I stop this from occuring?

Reply to this Message

Doug Robbins - Word MVP - 26 Sep 2006 18:17 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.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

> Hi
> I'm almost computer illiterate so didn't understand a word of Graham's
[quoted text clipped - 18 lines]
>>
>> How do I stop this from occuring?

Reply to this Message

vetondenet - 11 Nov 2006 09:32 GMT

Dear Doug,
Never visited this site since you gave that suggestion so apologies for the
delay in thanking you. Works perfectly!
Thanks again

Signature

vetondenet

> See the "Dates: day/month reversed" item under the "Connection methods"
> topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
[quoted text clipped - 23 lines]
> >>
> >> How do I stop this from occuring?

Reply to this Message

Peter Jamieson - 26 Sep 2006 20:48 GMT

> Anyway, my brother got me around the problem of
> Americans and their rubbish inability to do things properly like the rest
> of
> the world..

Gee, what on earth do you mean?

I'm not an American, but...

...you mean like Europeans nearly destroyed themselves twice in the 20th
century and were baled out by Americans who sacrificed their lives even
though they didn't really have to?

Or you mean like someone in Europe invented A1/A2/A3 paper sizes? That kind
of important thing?

Or what?

Peter Jamieson

Reply to this Message