Hi,

Is there a way in VBA to email a spreadsheet as password protected? This is what I want to do:

1. Open a new spreadsheet and populate it.
2. Email it with Microsoft Outlook (spreadsheet has to be pwd protected).

Then is there a way to delete the spreadsheet after it is sent? For security reasons, we don't want a saved version to be hanging around. This entire process will be automated, and nobody will be monitoring it daily to delete the spreadsheets.

Thanks,
Janice Suzuki

Hi

Since you are going to send the entire sheet you can try SendMail in Excel (ActiveWorkbook.SendMail)

Else you can go for Outlook VBA (http://vbadud.blogspot.in/2007/04/vb...-vba-mail.html)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)