Re: Mail merge does not keep formatting from excel into word document

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

There are usually two options:
a. use a format switch in Word, e.g. use Alt-F9 to show the underlying field codes and change

{ MERGEFIELD myamount }

to

{ MERGEFIELD myamount \#"$,0.00" }

b. check Word|Tools|Options|General|"Confirm conversion at open", go through the process of connecting to Excel again, and choose the DDE option when prompted. However, that's the "old" approach, requires Excel on your system, requires that the data is in the first *** in the workbook, and won't work with Unicode characters outside the ANSI set (more or less).

Peter Jamieson

"Luke" <Luke@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A6BD83B4-A598-44AA-89DA-D025698743CB@xxxxxxxxxxxxxxxx
The Microsoft demo uses an example of sending a letter to all employees about
their current salaries, but when I enter a dollar amount into an Excel
spread***, say $50,000.00 (formatted as Currency) it comes out in the mail
merged Word document as 50000; non of the formatting comes across and I can
find no easy solution to this.

.

Quantcast