Terry, this is exactly what I need. Thanks. Important question for me: The Outlook application you are connecting to is actually on the SQL Server box itself, correct? That is, your code does NOT access the Outlook application on the box of the person that might execute this DTS package. Am I correct?
Set objOutlook = CreateObject("Outlook.application")
Set mNameSpace = objOutlook.GetNameSpace("MAPI")