Data is in Excel - Date is 6th Apr in spreadsheet. This changes when
mailmerged the format changes to 4/06 - This merges correctly using Windows
95.
Is there something I need to do in Windows XP in order for this to mail
merge correctly.

Which version of /Word/ ?

Peter Jamieson
"Lynsoo" wrote in message
...
Data is in Excel - Date is 6th Apr in spreadsheet. This changes when
mailmerged the format changes to 4/06 - This merges correctly using
Windows
95.
Is there something I need to do in Windows XP in order for this to mail
merge correctly.

2003

"Peter Jamieson" wrote:

Which version of /Word/ ?

Peter Jamieson
"Lynsoo" wrote in message
...
Data is in Excel - Date is 6th Apr in spreadsheet. This changes when
mailmerged the format changes to 4/06 - This merges correctly using
Windows
95.
Is there something I need to do in Windows XP in order for this to mail
merge correctly.

Try either of the following in Word:

Use Alt-F9 to look at the field codes in your document. Change e.g.

{ MERGEFIELD mydate }

to

{ MERGEFIELD mydate \@"DD/MM/YYYY" }

or amend that to give you the format you want.

If that does not work, I beieve it is because of a problem in the OLEDB
provider which gets the data from Excel, and you can either
a. contact Microsoft Customer Service and see if they have a fix or
b. check Word Tools|Options|General|"confirm conversion at open", go
through the connection process again, and choose the DDE option when it is
offered.

Peter Jamieson


"Lynsoo" wrote in message
...
2003

"Peter Jamieson" wrote:

Which version of /Word/ ?

Peter Jamieson
"Lynsoo" wrote in message
...
Data is in Excel - Date is 6th Apr in spreadsheet. This changes when
mailmerged the format changes to 4/06 - This merges correctly using
Windows
95.
Is there something I need to do in Windows XP in order for this to mail
merge correctly.