Hi Richard,

You could store the csv data in a password-protected zip file or, alternatively, import the data into a password-protected Word
file. I'm not sure but, if you use the latter and make it your data source, the mailmerge process should prompt you for the password
before executing the merge.

Cheers

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...