Mail merge does not keep formatting from excel into word document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luke - 07 Aug 2007 20:50 GMT

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.

Reply to this Message

Peter Jamieson - 08 Aug 2007 00:22 GMT

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

> The Microsoft demo uses an example of sending a letter to all employees
> about
[quoted text clipped - 4 lines]
> can
> find no easy solution to this.

Reply to this Message

Doug Robbins - Word MVP - 08 Aug 2007 00:33 GMT

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

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

Signature

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

> The Microsoft demo uses an example of sending a letter to all employees
> about
[quoted text clipped - 4 lines]
> can
> find no easy solution to this.

Reply to this Message