Word Mergefield problems?

[Damon]

Hi,

I have an Excel 2000 datasource which merges it's data into Word 2000. I do
this by taking the data from sql server putting into VB doing my
calculations and then performing the mail merge. Problem I'm having is when
using percentages, when I open up my datasource it is displaying as i.e. 40%
but it is going into Word as 0.4 because of the formatting in Excel. Is
there any way I can get the merge fields in Word to display the datasource
fields as they look in Excel? Would appreciate any help on this.

Thanks

Damon

 

[Doug Robbins]

Add a formatting switch to the mergefield. See "Formatting Word fields with
switches" on fellow MVP Graham Mayor's website at

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


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP