MAPI vs CDONTS

[nickthompson]

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

[gavinpollock]

I've used CDONTS quite a bit now, and that error normally pops up when your SMTP server (either exchange, or IIS) isn't set up properly.

CDONTS.Newmail has to be used on a machine that has a SMTP server running on the same machine, so its fine for ASP pages and stuff.

Otherwise use CDONTS.Session and log on to an SMTP server and basically do the same thing as you're doing with the MAPI session.