Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2006

Tip: Looking for answers? Try searching our database.

Conditional mail merge calculation not printing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stevieb19 - 06 Oct 2006 06:55 GMT
I have the following field in my document:
{IF {MERGEFIELD "Type"}="A""""{MERGEFIELD "Base"}/2 \# "$0.00 }"}
When I "merge to a new document"the value shows up (If there is a value
there).
However when i "merge to printer", the value doesn't print out.

Is there anything that i can do to make the field print out when I merge to
printer?
I'm trying to do this in Word 2002
Graham Mayor - 06 Oct 2006 07:37 GMT
Your syntax is somewhat awry
Try
{ IF{ Mergefield Type }  <> "A" "{ =({ Mergefield Base }/2) \# ",$0.00" }"}

Signature

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

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

> I have the following field in my document:
> {IF {MERGEFIELD "Type"}="A""""{MERGEFIELD "Base"}/2 \# "$0.00 }"}
[quoted text clipped - 5 lines]
> merge to printer?
> I'm trying to do this in Word 2002
Stevieb19 - 09 Oct 2006 00:56 GMT
Thanks Graham,

I've amended the field like you said, however it still will not print the
value out when I "merge to printer". Is there anything that I can do to make
get tha value to print out?

Regards,
Stephen

> Your syntax is somewhat awry
> Try
[quoted text clipped - 9 lines]
> > merge to printer?
> > I'm trying to do this in Word 2002
Doug Robbins - Word MVP - 09 Oct 2006 04:39 GMT
Under Tools>Options>Print, make sure that the Update Fields box is checked.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thanks Graham,
>
[quoted text clipped - 20 lines]
>> > merge to printer?
>> > I'm trying to do this in Word 2002
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.