Mail merge date from Excel 2003 to Word 2003 in same format

[TP]

When I mail merge a date from an Excel 2003 spreadsheet to a MS Word 2003
document, it switches from dd-mm-yyyy to mm-dd-yyyy format. eg 18-03-2009
merges as 03-18-2009. Both the Excel and Word programs have their language
set at English (Australia), although the Word Language box has both English
(Australia) and English (US) listed, with English (Australia) set as the
default.

Does anyone have any ideas on how I can get the date to show in the correct
format, dd-mm-yyyy?
Cheers. Travers

 

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002/2003" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindymeister/MergFram.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

 

[TP]

Thanks Doug. i had a look at the information on the website that you
directed me to. Unfortunately, it meant nothing to me. I was hoping for a
simple solution!

I thought that if I could delete the English (US) from the language box,
leaving only English (Australia) it may help. But I don't know how to do
that.

I have performed the same mail merge in the past without this problem, so I
don't know why it's appearing now.

Maybe, I'll have to type the dates (in Excel) in text format!

Cheers. Travers

 

[TP]

Hi. I checked through a few other posts, on this site and found the solution
at:
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

In MS Word 2003 change one of the Word options settings i.e. Tools >
Options > General > Confirm conversion on open. (tick the "Confirm conversion
on open" box).

When you select the data source, when connecting to an Excel data file, a
"Confirm Data Source box appears, from which you should select DDE, whereupon
the the date will be merged in its correct format.

Worked for me.
Travers

 

[Doug Robbins - Word MVP]

Which is the same information as provided in the link to which I directed
you.

--
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