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 / August 2004

Tip: Looking for answers? Try searching our database.

Embedded SkipIF statement - HELP - CORRECTED

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Newbie@msn.com.INVALID - 09 Aug 2004 11:48 GMT
How can this be changed so that Word Accepts it rign now it does not
allow embeeded skipif statments

{ IF { MERGEFIELD CC_ApptDate } <>"" " {
SKIPIF { = { MERGEFIELD "CC_ApptDate"
\@ "M" }- { MERGEFIELD "CC_DueDate" @
"M" } < 0 }}" "" }

What I am trying to do is included ALL the records where {
MERGEFIELD CC_ApptDate }  is BLANK AS WELL AS SOME OF THE RECORDS
where {MERGEFIELD CC_ApptDate }  IS NOT BLANK

For the Non blank records I want to eliminate those people whose {
MERGEFIELD "CC_DueDate} is next  month and appointment date is this
month {MERGEFIELD CC_ApptDate }

If if I can do this I have not yey figured out how to deal with the
Dec/Jan Math problem

Just so you know I cannnot change the way the data file is genrated
since it is from another program

Just to simplify I want to send cards to those people who do not have
an appointment this month and are due to come in this month and those
who have appointments this month and are due to come in this month.  I
do not want to send cards to those people who are due this month but
had there appointments last month (they came in early)

TIA
Peter Jamieson - 09 Aug 2004 22:58 GMT
I would probably try something like

{ SET M1 12 }{ SET M2 1 }{ SET M3 2
}{ SET M4 3 }{ SET M5 4 }{ SET M6 5
}{ SET M7 6 }{ SET M7 6 }{ SET M8 7
}{ SET M9 8 }{ SET M11 10 }{ SET M12 11
}{ SKIPIF { =or({ COMPARE "{ MERGEFIELD CC_ApptDate }" = "" },
and({ COMPARE { REF "M{ MERGEFIELD CC_DueDate \@M}" } = { DATE \@M },
{ COMPARE { MERGEFIELD CC_ApptDate \@M } = { DATE \@M })) } = 1 }

Signature

Peter Jamieson

> How can this be changed so that Word Accepts it rign now it does not
> allow embeeded skipif statments
[quoted text clipped - 25 lines]
>
> TIA

Rate this thread:






 
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.