Mail Merge an excel file to word- loss of format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail merge between Word and Excel 1
Mail Merge Question with Excel 4
Mail merge date format 1
Word Mail Merge Formatting Issue Font Size 0
Mail Merge 1
Merge format switch issue? 4
Mail Merge 1
forms, data import excel, generate multiple pages 2

Back
Top