>Your article is very good. However, when I run your >code in my DTS package, Logon Box prompted. So I >should enter password to run through. Then how can I >make it a scheduled job and run it automatically? A >job cannot take input as far as I know.

Assuming the logon box your seeing isn't the DTS owner or user password (in which case Save As and clear those two password textboxes).

That will probably only happen if the user doesn't have privileges to outlook. Couple of possibilities: Are you using windows auth when accessing sql server? Does that user have access to outlook? What user is sql server using to run? Does that user have access to outlook?