Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Luke Luke is offline
external usenet poster
 
Posts: 34
Default Mail merge does not keep formatting from excel into word document

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mail merge does not keep formatting from excel into word document

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

"Luke" wrote in message
...
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.


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail merge does not keep formatting from excel into word document

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

"Luke" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Excel Data Using Mail Merge rythm Mailmerge 1 November 15th 05 05:59 AM
Excel Formatting in Mail Merge dpahlow@nwtc Mailmerge 1 July 29th 05 06:25 PM
Formatting fields in Word (using Excel as Mail Merge Data) - need. John Mailmerge 1 April 12th 05 12:24 PM
Formatting using Excel datasource for mail merge Shawna Mailmerge 1 February 26th 05 01:19 AM
Formatting zip code in mail merge from Excel to Word Zip code help Microsoft Word Help 1 February 10th 05 02:50 AM


All times are GMT +1. The time now is 03:26 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"