Results 1 to 2 of 2
2003-11-07, 10:01 #1
- Join Date
- Nov 2003
- Thanked 0 Times in 0 Posts
Merge ignores regional settings (Word 2002 SP2)
Mail Merge Word document using Excel data table. Word ignores regional settings, ignores formatting from Excel and just displays merged values in US formats. Now, we Brits express large values with comma separators (23,456) and dates in a different manner (31/03/1949) from the US, so UK secretaries have to format all such merged fields within the Word document using the formatting picture switch, which seems a bit tough. Why does Word respect regional settings most of the time but ignore them when mail merging?
Any fixes available - this is gonig to affect all our secretarial staff in the UK, and as I head the Helpdesk I'm desperate to fix it early in the Office XP rollout. No, we won't be using 2003, so that suggestion won't help!
Thanks in advance, guys.
2003-11-07, 10:17 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Merge ignores regional settings (Word 2002 SP2)
The default method of connecting to a data source in Word 2002 is OLE DB. For Excel, however, DDE is better.
Select Tools | Options...
Activate the General tab
Tick the 'Confirm conversion at Open' check box.
From now on, Word will ask which method you want to use to open the Excel data table: OLE DB, Converter, DDE or ODBC. Select 'MS Excel worksheets via DDE (*.xls)'. This will preserve the formatting set in Excel.