Automatic MS Access email -- how to ENCRYPT first??

[cailie]

Hello everyone,

I'm developing an application in MS Access/VBA.

It has a button that automatically sends a report (as an email attachment) to a remote employee.

The problem is, this report contains a credit card number.
Is there a way (using Visual Basic from within the application) to encrypt the attachment (with PGP) before it is attached?

I almost think this can't be done, but I thought I would throw it out there....

Thanks for reading this.

-C

 

[kylua]

As an alternative to encryption, you could try just saving it password protected initially. This should mean that it is sent with the password which would be needed at the far end to open it.

It worked when I tested it with Send To. If you're sending by manipulating your mail prog, it should work as well.

 

[cailie]

Hi Kylua,

I appreciate your idea. I really have to encrypt these files however. If I used password protection, I'd be afraid of someone cracking into it.

I thought about this problem, and I think that what I can do is: take the credit card number out of the attachment, and put it in the body. Then my user can just encrypt the email contents when he sends it.

Best regards,
-C