mail merge with currency

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelly - 06 Jul 2005 00:10 GMT

I have been reading and trying, but I still can't figure this out. I am
trying to format a merge field to display as currency. I am following the
directions in the Word Help menu, but after I click altF9, I get a strange
number that is not correct.
Can someone please tell me in real easy terms, what my field should look
like when I am finished. I am merging from an access query. Where is this
code (\#) supposed to go, and do you keep the parenthesis? I have found
where I can right click and edit field, but I get nowhere there also.

Please help!!!

Reply to this Message

Anne Troy - 06 Jul 2005 00:19 GMT

Try this, Kelly:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> I have been reading and trying, but I still can't figure this out. I am
> trying to format a merge field to display as currency. I am following the
[quoted text clipped - 6 lines]
>
> Please help!!!

Reply to this Message

Kelly - 06 Jul 2005 00:41 GMT

I have got to be the stupidest person here, because these instruction seem
easy enough for my 11 year old, yet I still can't get it.

Here is what my document looks like.

{MERGEFIELD "Current_Month_Total" \# "$,0.00;($,0.00)"}

Do you see anything wrong with this?

I am now just getting my origianal Data without it looking like currency. - 25

Thanks for answering so quickly before. I would really like to get these
receipts out today before I go home.

Kelly

> Try this, Kelly:
> http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
[quoted text clipped - 15 lines]
> >
> > Please help!!!

Reply to this Message

Kelly - 06 Jul 2005 00:51 GMT

Ok, I got rid of the stuff in parenthesis ($,0.00) and it worked. Do I need
that info?

> I have got to be the stupidest person here, because these instruction seem
> easy enough for my 11 year old, yet I still can't get it.
[quoted text clipped - 31 lines]
> > >
> > > Please help!!!

Reply to this Message

Anne Troy - 06 Jul 2005 01:05 GMT

Doubtful. The parentheses are how it should display negative values. If you
won't have any negative values, you should be fine. And I can't see any
reason why it didn't work. :(
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> Ok, I got rid of the stuff in parenthesis ($,0.00) and it worked. Do I need
> that info?
[quoted text clipped - 16 lines]
> >
> > > Try this, Kelly:

http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm

> > > *******************
> > > ~Anne Troy
[quoted text clipped - 13 lines]
> > > >
> > > > Please help!!!

Reply to this Message

Rate this thread: