When I import (?) data into word through a mail merge, how do I keep format

[emandel]

So I am importing data from a query into MS word for a mail merge, and one of the fields is a $ amount. In Access it is formatted properly as a currency and shows up fine on the screen (e.g. $24,000), but in MS Word, when I run the merge (or preview it) it comes out without the $ and with out the comma (e.g. 24000).

Please help

[missinglinq]

I think the formatting has to be done on the Word end. Here's a link on the subject:

http://office.microsoft.com/en-us/word-help/answer-box-numbers-don-t-merge-right-in-word-HA001116495.aspx?CTT=1&origin=EC001022717

About two-thirds of the way down the page they actually use currency as an example of formatting text.

Linq ;0)>