Hi

Just to clarify, when you say 'But when I run the package in SQL, it prompts for Profile Name in Outlook. ' do you mean you're running it on a different computer?

If so, the MAPI control will be looking for a default mailbox to send from, or if you're specifying a profile that hasn't already been set up on the SQL PC then it's asking for the profile because it doesn't recognise the one you've specified.

Don't know if that helps. I can't help with the CDONTS problem