> I'll send you the DB, the doc file and the result file if
> you'd like.
> .xls file is 21.5 Kb,
> .doc file is 51.5 Kb,
> Result file is 37.5 Kb
It's not "if I'd like". I'd rather
a. you described your fields more precisely (I could only really guess based
on the information you provided, but I hope I showed you how you could
describe those fields more clearly)
b. you described what steps you were taking to perform the merge
c. you told us which version of Word you are using. 2000? 2002? 2003?
d. people didn't say "I don't understand what you said" without providing
any clues whatever about what it is they do not understand.
e. people did not assume that just because something seems to work most of
the time, it is a sound basis for creating something that works all of the
time.
You can despam my address and send me the stuff if /you/ like. But I still
need to know the answers to (b) and (c).
--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/
Hi,
I don't understand what your saying.
My Mail-merge program works. I can "fill-in" the first
date, "Fill-in" the second Date etc. for 5 dates click OK
and get 5 pages of "results". If I "fill-in" Jan 4 2004
as the first date the mail-merge doesn't ask for the
remaining 5 dates, the only problem and question is why
then and not any other time.
I'll send you the DB, the doc file and the result file if
you'd like.
.xls file is 21.5 Kb,
.doc file is 51.5 Kb,
Result file is 37.5 Kb
Then you can run it and see what I'm questioning?
Thank you for your time and patience,
Mr K
>-----Original Message-----
>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.
>
[quoted text clipped - 165 lines]
>
>.