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 / July 2003

Tip: Looking for answers? Try searching our database.

Mail Merge Inserts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Clive Prideaux - 30 Jul 2003 20:17 GMT
How do "Skip Record If" and "Next Record If" work? I would
like to insert a variable only if that variable has a
particular value. Thanks for your help.
Peter Jamieson - 30 Jul 2003 23:06 GMT
SKIP IF and NEXT IF etc. make Word move to the next /record/ To make the
output appear different depending of the value of a field, you need to do
one of the following:
a. ensure the "Suppress Blank Lines in Addresses" option is checked. This
actually makes any line containing nothing except empty fields disappear,
unless you're using Word XP or later and the lines are inside the result of
another field such as an IF. If you are using Word XP or later you also have
to revive the old MailMergeHelper dialog box using Tools|Customize if you do
/not/ what this option to be set
b. use an { IF } field, e.g.

{ IF "{ MERGEFIELD myfield }" = "A" "A" "" }

or whatever.
c. in Word XP and later you may be able to use additional switches to get
what you want when the field is non-blank, but I don't think itis applicable
in the case you describe.
--
Peter Jamieson
MS Word MVP

> How do "Skip Record If" and "Next Record If" work? I would
> like to insert a variable only if that variable has a
> particular value. Thanks for your help.
Clive - 31 Jul 2003 20:58 GMT
Peter

Thanks for your help. I think we're getting closer. What
if I wanted to suppress a variable if it equaled the
value "downtown" and display it in all other cases. In
other words the IF statement has to specify the output of
the variable not a text statement when true and blanks
when false.

Clive


>-----Original Message-----
>SKIP IF and NEXT IF etc. make Word move to the next /record/ To make the
[quoted text clipped - 23 lines]
>
>.
Peter Jamieson - 31 Jul 2003 23:41 GMT
Try

{ IF "{ MERGEFIELD myfield }" = "downtown" "" "{ MERGEFIELD myfield }" }

--
Peter Jamieson
MS Word MVP

> Peter
>
[quoted text clipped - 47 lines]
> >
> >.
 
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.