Mailmerge on word using excel data

[RJP]

Hello.

I am trying to mailmerge a word document using data from an excel
spreadsheet. Despite the spreadsheet being formatted to English dates
(dd-mmmm-yy) and numbers to 0 decimal places when the documents merge the
dates show as American (mm/dd/yy) and the figures to 10 decimal places. I
have checked my system is set up in English format but am unaware of what
else can be done.

Any ideas.

Thanks.

RP

 

[DB Queen (Not)]

Have you tried going into the control panel and regiional options and date
and making sure that the default date setting is dd-mm-yy?

 

[RJP]

Unfortunately I have tried this and it does not solve the problem

 

[Peter Jamieson]

Usually you can solve these things if you use the DDE connection method - in
Word 2002/3 check Tools|Options|General|"Confirm conversion at open", go
through the connection process again, and select the DDE option when
offered.

Otherwise, try using Alt-F9 in Word to view the raw fields and change, e.g.

{ MERGEFIELD mydate }

to

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

and

{ MERGEFIELD mynumber }

to something like

{ MERGEFIELD mynumber \#0 }

There is more in Graham Mayor's article at

http://www.gmayor.com/formatting_word_fields.htm

If you can't get the month and date to appear in the right order using
\@"DD/M/YYYY", it is probably because of a problem in the OLEDB provider
that Word is probably using to get the data. The DDE approach should solve
that, but at one point Microsoft offered a fix - you would have to contact
their Customer Support Services for more info. on that.

Peter Jamieson

 

[RJP]

Your first suggestion has worked a treat and all is now fine for both the
dates and numbers.

Thank you for taking the time to suggest the solutions.

Regards.