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.