Mail merge does not keep formatting from excel into word document

[Luke]

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
spreadsheet, 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.

 

[Peter Jamieson]

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 sheet in the workbook, and
won't work with Unicode characters outside the ANSI set (more or less).

Peter Jamieson

 

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP