Re: Merge in Word
- From: kat <kat@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 2 Mar 2007 08:37:13 -0800
Peter - that was the problem! I had the "next record" field in the wrong
place. At least it worked on the latest form. Will have to see what it does
in the rest of the forms. Never thought about that field being in the wrong
place.
Thanks again for your time and help.
Kat
"kat" wrote:
Thanks, Peter. I have never been able to figure out. But I just saw.
something in this same forum about missing data and where the "next record"
code is located. I'm wondering if that's part of the problem. I'm going to
check some of my forms out. It's not the same problem this woman was having
(here's was missing at certain numbered entries - mine is variable). I had
this forum set up to notify me of "replies" but I guess that didn't work.
I'm not on this forum very often.
Thanks for you help.
Kat
"Peter Jamieson" wrote:
Sorry, but it would be difficult to send you this. As I said, I deal with
addresses, names, etc., and don't wish to send this.
Understood.
Once it decides it's not going to add the data - that's the way it is. It
would be the same data always missing.
OK, over the years there have certainly been one or two problems where (for
example) blank cells cause the data in the row above to be repeated, that
sort of thing, but I suppose the two things I would always look for are:
a. is there anything "unusual" in the problem row (or the row before).
Unusual would most likely be "unusual" characters such as double-quotes, or
in the case of a Word table which can contain all sorts of stuff other than
plain text, it might be something like formatting left in the table, or
field codes, embedded objects and so on.
b. does the problem seem to be associated with the data, or the position of
the data. Position could mean "there's always a problem with row 250 in data
source xyz.doc" or "there's always a problem after around 65536
characters" - that sort of thing.
Not sure I can offer much more than that.
Peter Jamieson
"kat" <kat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D817DAD1-0C2A-481E-A272-D29853EFEF42@xxxxxxxxxxxxxxxx
"Peter Jamieson" wrote:
1. Which version of Word?
This has happened once in a while in every Word that I've used going back
to
'97 - I'm using '03 now. Has happened on my computer and has happened at
work when I didn't use Excel for the database.
2. If you repeat the "bad" merges, do they always behave the same (bad)
way,
or does the behaviour vary?
Once it decides it's not going to add the data - that's the way it is. It
would be the same data always missing.
3. For a data source that causes problems, does it cause problems no
matter
what you put in the Mail Merge main document (e.g. if you put a simple
list
of all the fields in, and nothing else, do you see the same problem?
This has happened when the database is a simple address database in table
format to a more complex table (by complex, it holds more data in a cell
than
an address). For example, I have created a database to use for a quilt
show
that had the maker's name all the way to a description or story about the
quilt. It doesn't happen all the day, but when it starts, there's nothing
I
can do. I've tried making a new "form" to use in the merge in case the
file
I was using was corrupt. Still would do it and it would be the same one.
I
have opened the database up again and have check the recepients again.
Other
forms to use various portions of the info work just great - and using the
same info but in a different manner (e.g., a variation in the table
perhaps -
most of the time I'm working with names, addresses, etc.). It's
frustrating
when it happens. I don't remember it happening when creating labels, but
I
could be wrong about that. I get to use "old" as an excuse for memory.
4. Do you have examples that you would be able to e-mail? If so, if you
want, take the "KillMAPS" out of my e-mail address and email a couple of
samples.
Sorry, but it would be difficult to send you this. As I said, I deal with
addresses, names, etc., and don't wish to send this.
Kat
- Follow-Ups:
- Re: Merge in Word
- From: Peter Jamieson
- Re: Merge in Word
- References:
- Re: Merge in Word
- From: kat
- Re: Merge in Word
- Prev by Date: Re: My zip code field on the mail merge drops leading zeroes, why?
- Next by Date: Re: Merge in Word
- Previous by thread: Re: Merge in Word
- Next by thread: Re: Merge in Word
- Index(es):
Relevant Pages
|