Word Mergefield problems?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Damon - 20 Aug 2004 11:00 GMT

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

Reply to this Message

Doug Robbins - 20 Aug 2004 23:57 GMT

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

Signature

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

> Hi,
>
[quoted text clipped - 12 lines]
>
> Damon

Reply to this Message