Securing a .RTF File for E-mailing

[Capilano]

Hi...

Using a very straight forward SendObject acSendReport statement in an Access 2002 function, I have successfully created a Rich Text File (.rtf) ready for e-mailing. All works very smoothly. My dilemma, however, is that often times the information being e-mailed is sensitive and must be secured.

Using code, is there a way to go one step further and make this newly created .rtf file password secured?

Any code, or references to how to accomplish this task would be appreciated.

Thanks

Pat

 

[Uncle Gizmo]

I think you can programmatically control winzip. I don't no how, you could then zip your new file with a password and send that.

I think Roger Carlson has an example, (very old command line stuff) I recall on his website.

Haven't got a clue if it will be of any use, I haven't looked at it.

 

[Uncle Gizmo]

Have now had a quick look, I think it has potential.

Please note that you may have to do the following depending on which Ver of Access you are running:

Change all occurances of:

Dim MyDB As Database
Dim MyTbl As Recordset

to:

Dim MyDB As DAO.Database
Dim MyTbl As DAO.Recordset