[softwarelist] Re: Mail Merge Problem with Ovation Pro (RO)

In article <n5UjnfB0KJEJFwpF@xxxxxxxxxxxxxxxxxxx>,
   David Pilling <flist@xxxxxxxxxxxxxxxxxxx> wrote:
> In message <4ff9093acbSteve@xxxxxxxxxxxxxxxxxx>, Steve Joyce 
> <Steve@xxxxxxxxxxxxxxxxxx> writes
> >I've attempted to use mail merge to print some address labels using a
> >CSV file exported from Excel - with mixed success.

> It is hard for me to say without seeing the CSV file and the OP
> document you're using with it - feel free to email them to me
> privately.

> It could be something dozy like line endings, say the file uses the
> Windows standard of CRLF and OP reads the CR or LF as a blank record.
> If that was the case you could fix it by changing the line endings in
> Edit or making use of the OP mailmerge "fields" feature to skip
> records - if you're using fields already just stick in another
> nextrecord() command.

The problem exactly. The problem with using Zap as an editor is that it
can be set to hide CRLF from DOS files and retain it as the line
terminator. I knew this but got the same result having used ViewXLS to
produce the text output from the original Excel file - then I assumed
that something else was causing the problem.

Viewing the file in Edit showed the extra x0D at the end of each line.
Removing these did indeed remove the extra blank output record between
each real record.

Now to find out how to switch the behaviour of Zap so that I stand a
chance of avoiding said problem.

Many thanks,

Steve

To unsubscribe or subscribe goto: http://www.freelists.org/list/davidpilling

Other related posts: