Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Mail Merge an excel file to word- loss of format

Either connect to Excel via DDE rather than OLEDB or use formatting
switches; see http://www.gmayor.com/formatting_word_fields.htm.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"spatrsculp111" wrote in message
...
I am trying to merge data points from excel into a letter in Word, and

when I
do all the formatting in the excel file is lost. For example I am

inserting
a cost and instead of $50.00 I get 50.00000. How do I fix this. It shows

up
in excel the way I want.


 
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
Values will not keep format from Excel to Word xp mail merge bioteacher Mailmerge 12 October 15th 07 05:32 PM
Mail merge Labels Excel to Word - Need Help with format of numbers [email protected] Mailmerge 1 November 9th 06 08:54 PM
Word mail merge ,label format ,using an Excel file. K Mailmerge 1 September 7th 06 09:57 AM
mail merge from excel that changes my format from UK to US format mark Mailmerge 0 January 21st 05 03:01 PM
Word mail merge data loss Gibson Mailmerge 1 December 8th 04 01:30 PM


All times are GMT +1. The time now is 05:18 AM.

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

About Us

"It's about Microsoft Word"