[Peter Jamieson]

1. macropod's .doc solution should work. If necessary, the .doc's password
can also be passed as a parameter in a Word VBA OpenDataSource call,
although the password would then be embedded in the relevant Word Mail Merge
Main Document and might be fairly easy to discover.

2. Otherwise, the only way I know to do this would be to write a text
converter that could read an encrypted file and convert it into a delimited
file in RTF format. Non-trivial (you have to get the converter SDK anf code
this sort of stuff in something that can produce a traditional WIn32 .dll,
e.g. C, C++, Delphi), you have to do special stuff to avoid further security
questions by Microsoft software, and you have to distribute the converter to
all your users. And you have to do the other bit, i.e. write something to
encode your csv s.

If you're trying to guard against deliberate hijacking of data, you then
have to be sure that your encryption algorithm is not easily cracked and
that any keys etc. are well guarded. And so on...

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Richard Relpht" wrote in message
...
Yes, I do actually know what csv files are.
But I imagined that it would be possible in a CSV file to preserve the CSV
structure and simply garble the field contents. But that would require
that Word have some way to ungarble if the user provided the correct key.
... Which was why I was asking the question.


Example of the straight CSV data:
Name;Ad1;Ad2;ZIP;City
Lily;1 Gas Street;;70411;Gasville
Billy;2 Main St;Joborough;Soupsville

which, when, garbled would look like this:
Name;Ad1;Ad2;ZIP;City
GVDVCG;BVKJUY;GTFRFD45;MLOIN;GTFCDXS
HBVBOLK;TREDSEZ;GTFRDES;BVHGFVC

or even this:
DSDQAML;MLQNBGT;YBGTRFE;YHYHBM5;25FDCSM
GVDVCG;BVKJUY;GTFRFD45;MLOIN;GTFCDXS
HBVBOLK;TREDSEZ;GTFRDES;BVHGFVC

has no-one ever come up with a trick like that ?

Richard