Are you writing the text file while the Word mail merge main document is
open, with the .txt file open as the data source? (Actually, I am not sure
that you can do that, but if you can, I'm wondering whether Word can get
confused).
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Mike" S wrote in message
...
I started out with a text data file layout with such fields as
name, addr1, addr2, addr3, postcode
and from there I built a "labels" mailmerge document
In my excel application, I ask how many avery labels I want to skip, since
I may only be printing one or two labels each time and may have used
labels at the start, so I write the appropriate number of blank lines with
say just 4 vbTab characters
Then I write the data, and open the mailmerge document which uses the text
file as its data source.
Often the first time the processed mailmerge document is produced, the
number of blank labels is wrong - it's usually 1 too many. At this point
I manually took a copy of the data source. My app asks if the labels were
OK, so I say No, and I repeat the process. This time, the number of blank
labels is correct. This is despite the "size" attribute (not size on
disk) for both files being exactly the same.
I didn't have this problem in Word 2000, although when I migrated to 2003
I had to recreate the mailmerge document, because the user interface I was
presented with didn't seem to work quite right on a 200 file (maybe I kept
getting popups about version diffs I can't quite remember)
Anyway I've just managed to find SP3 for 2003, but is this a known bug? I
couldn't find it documented anywhere
--
Mike News