August 26, 2002 at 12:54 pm
We recently discovered the extra security in Outlook 2000 prevents us from sending automated email messages to our clients.
I discovered that the xp_sendmail procedure will fill the bill for us in some cases.
My question is: Has anyone called this function from Access 2000? Any pointers would be appreciated.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 26, 2002 at 2:22 pm
It will work, you'll have to adjust permissions on it though. Since Outlook is locked down once you apply any of the newer Office service packs we've moved to CDO via a central table for email. I just use xp_sendmail for job notifications.
Andy
August 26, 2002 at 2:30 pm
What is CDO? Our office standard is outlook with exchange.
When I tested xp_sendmail on our query analyzer it worked. What is the permissions problem within Access?
Thanks for the followup.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 26, 2002 at 5:17 pm
Collaboration Data Objects check MSDN and here a link to an Intro http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexch55/html/msdn_introcdo.asp
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 26, 2002 at 6:45 pm
Permissions default to dbowners and sysadmins, you just have to grant others access.
Andy
August 29, 2002 at 8:21 am
I have a similar requirement. Having provided an emailing ability for my client using xp_sendmail, they are now talking about needing formatted output, for example using HTML.
Is there a way that I can do this with xp_sendmail, aside from building each page as a text file, then attaching it?
Thanks
Simon
PS Does CDO use COM (sp_OACreate)?
August 29, 2002 at 8:39 am
CDO does use COM.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
August 30, 2002 at 2:39 pm
A SOLUTION
In response to the “Mail problem” which is actually a security feature to prevent Loveletter type viruses, I have downloaded a product called Express ClickYes. This product does the following:
Express ClickYes 1.0.1
What is Express ClickYes Express ClickYes is a tiny program that sits in the System Tray and clicks the Yes button on behalf of you, when Outlook's Security Guard opens prompt dialog saying that a program is trying to send an email with Outlook or access its address book.
I tested this using the email addresses in the Outlook Address Book for one of our users and was successful in sending a mail merge document using a Word through electronic mail. Because activation leaves the system vulnerable to Loveletter type viruses, the software can also be managed by third-party software like VB to activate or suspend automatic clicking. This is a FREE download of only 80kb at <http://www.express-soft.com/mailmate/clickyes.html>
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 30, 2002 at 3:54 pm
You can find information on sending HTML mail from sql using CDO on
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply