OK, your description suggests that you have fields which look something like
this:
{ IF { MERGEFIELD Date } = { FILLIN }
"fields and text for the first week you want as per your example"
"{ IF { MERGEFIELD Date } = { FILLIN }
"fields and text for the second week you want as per your example"
"{ IF { MERGEFIELD Date } = { FILLIN }
"fields and text for the third week you want as per your example"
"" }" }" }
except that you have 5 rather than 3.
This is not really going to work because it is based on a misunderstanding
of how a mailmerge and the { MAILMERGE } fields are supposed to work. When
you open this document, in effect each { MERGEFIELD Date } will have the
same value. Typically it will be the value of the first date in your
spreadhseet, but it may be one of the later dates if you have changed the
record currently being previewed using the << and >> buttons (either in the
mail merge toolbar or the mail merge wizard). Let's assume for the moment it
is the first, i.e. Jan 4 2004.
So Word then executes the first FILLIN and you supply a date. If you enter
Jan 4 2004, the comparison will succeed and Word will simply insert
"fields and text for the first week you want as per your example"
It will not execute the other FILLIN fields because they would only be
executed if the comparison had failed.
If you enter a different date such as Jan 11 2004, the first comparison will
fail. So you should not see
"fields and text for the first week you want as per your example"
but you will see the next FILLIN. And so on. This isn't quite what you
describe but I think that is what is happening.
So what should you be doing? Well, of course it depends on a number of
things, not least what output you are trying to get and why you are storing
your data in the format you are using. But let's suppose that what you want
is to produce the data for the forthcoming few weeks. Then it would probably
be simpler just to leave out all the IF statements and FILLIN statements,
leave this lot
"fields and text for the first week you want as per your example"
in there, and use the "Edit recipient list" facility to select the 5 weeks
you need to produce data for, then perform the merge. That shoud be
reasonably straightforward but let us know if you do not understand what I'm
suggesting.
--
Peter Jamieson - Word MVP
Word MVP web site
http://word.mvps.org/
The source looks like this:
Date Lecter Minister Server Greeter Gifts
Jan 4 2004 Joe Mary Tom Jack Murphy
Jan 11 2004 etc.
There are 52 weeks of data (all Sunday Dates)
The program Looks like this
An "IF" "Then" "Else" Statement!
If (Field Name)" " (Comparison)" " (Compared TO)" "
(Insert Text)
(Otherwise Insert this Text)
Field Name = "Date"
Comparison = "="
Compared To = "Fill-in"
Insert Text = "My text"
Otherwise Insert This Text = "Next IF statement"
There are 5 "If" statements each has the same format
except the last one. It's Otherwise.... ends in "".
This the first page of 5. Here it did not format
correctly but I think you can get the message.
Our Lady of the Assumption Catholic Church
Rev. Charles M. Hughes, Pastor
(912)564-2312
§§§
Mass Schedules
Monday:
Tuesday:
Wednesday 5:30 PM
Thursday:
Friday 10:00 AM
Saturday 5:00 PM
Sunday 9:00 AM
§§§
Feb 1 2004
§§§
Liturgy Schedule
Lector:
K. Brennan
Greeters / Ushers:
C. McCord
E. Mingle
Eucharistic Ministers:
B. Francis
P. Francis
Gift Bearers:
Brennan
Servers:
C. Cannon
T. Driggers
CCD Refreshments:
Kirkland
If you are unable to serve, please arrange for a
replacement
Thank you!
§§§
Church Notices:
If I enter Jan 4 2004 as the first "fill-in" the program
does not request the remaining entries. It does give the
5 weeks data. If I enter the second date or any other
date as the first "fill=in" date the remaining 4 "Fill-
in" requests are made. The result of this pass is
totally correct.
Hope this make the problem clearer.
Thank you for your time and patience.
Mr K
