Dollar signs from Access data to Word in a Mail Merge? SH 5/14/2007 4:49:01 PM In doing a mail merge in Word 2007 my dollar signs and decimal places don't carry over from my Access query. Suggestions?

Re: Dollar signs from Access data to Word in a Mail Merge? dave <dlevy[ at ]nyc.rr.com> 5/14/2007 5:27:11 PM On May 14, 12:49 pm, SH <S...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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

Re: Dollar signs from Access data to Word in a Mail Merge? "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 5/15/2007 5:12:27 AM 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 -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> dave wrote: [Quoted Text] > On May 14, 12:49 pm, SH <S...[ at ]discussions.microsoft.com> wrote: >> 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

Re: Dollar signs from Access data to Word in a Mail Merge? SH 5/15/2007 4:17:01 PM It worked - thanks much for your help. SH "dave" wrote: [Quoted Text] > On May 14, 12:49 pm, SH <S...[ at ]discussions.microsoft.com> wrote: > > 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 > >

Re: Dollar signs from Access data to Word in a Mail Merge? SH 5/15/2007 4:18:01 PM This worked also - thanks very much. SH "Graham Mayor" wrote: [Quoted Text] > 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 > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > dave wrote: > > On May 14, 12:49 pm, SH <S...[ at ]discussions.microsoft.com> wrote: > >> 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 > > >