Dollar signs from Access data to Word in a Mail Merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SH - 14 May 2007 17:49 GMT

In doing a mail merge in Word 2007 my dollar signs and decimal places don't
carry over from my Access query. Suggestions?

Reply to this Message

dave - 14 May 2007 18:27 GMT

> In doing a mail merge in Word 2007 my dollar signs and decimal places don't
> carry over from my Access query. Suggestions?

right click on the field, clikc on toggle field codes. make it look
like this MERGEFIELD your field name\#$,##0.00

Reply to this Message

Graham Mayor - 15 May 2007 06:12 GMT

The extra hashes are superfluous \# "$,0.00" or \# $,0.00 (I prefer to use
the quotes) will work equally well
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

>> In doing a mail merge in Word 2007 my dollar signs and decimal
>> places don't carry over from my Access query. Suggestions?
>
> right click on the field, clikc on toggle field codes. make it look
> like this MERGEFIELD your field name\#$,##0.00

Reply to this Message

SH - 15 May 2007 17:18 GMT

This worked also - thanks very much. SH

> The extra hashes are superfluous \# "$,0.00" or \# $,0.00 (I prefer to use
> the quotes) will work equally well
[quoted text clipped - 5 lines]
> > right click on the field, clikc on toggle field codes. make it look
> > like this MERGEFIELD your field name\#$,##0.00

Reply to this Message

SH - 15 May 2007 17:17 GMT

It worked - thanks much for your help. SH

> > In doing a mail merge in Word 2007 my dollar signs and decimal places don't
> > carry over from my Access query. Suggestions?
>
> right click on the field, clikc on toggle field codes. make it look
> like this MERGEFIELD your field name\#$,##0.00

Reply to this Message