Solved

Alternative to SendObject for Sending E-mail

Posted on 2006-07-17
7
650 Views
Last Modified: 2011-10-03
Can anyone suggest an alternative to SendObject for sending E-mail from an Access 2000 database?  I'm willing to buy a package if that's the easiest.  I'm looking for something reliable which SendObject is not.
0
Comment
Question by:schmir1
  • 3
  • 2
  • 2
7 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17126694
Alternatives - Outlook Automation or CDO (Collaboration Data Objects)

CDO uses Exchange so u dont get the security message

See my sample code here
http://www.experts-exchange.com/Databases/MS_Access/Q_21866975.html

And see this regarding outlook security popup
http://www.experts-exchange.com/Databases/MS_Access/Q_21904604.html
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 300 total points
ID: 17126918
I had several issues with SendObject, and I just can't consider using software like Click Yes to kludge around the security warnings (and many corporate IT depts won't let you do this either). I've never used CDO, but others report it works well. I'm not sure how well it handles items like HTML body, etc so can't really comment on that.

FWIW, I ended up purchasing the Codestone mail library, and have used it for several years now (probably sent half a million emails with it over that time period) with no hitches - not one - and I've been able to make my corporate clients VERY happy that they don't have to muck around with security or install kludges. At $89 USD it's cheap and does everything you could possibly need:

www.codestone.co.uk

0
 

Author Comment

by:schmir1
ID: 17139304
LSMConsulting:
  I'm doing e-mail internal to my company using Microsoft Outlook.  Would Codestone be appropriate for that.

I shouldn't have any security issues.  I'm using SendObject now and it stopped working with our lasted corporate PC image.  In other words, all our new PCs don't send my database e-mail using SendObject.  I understand there is a fix but I am considering better options (SendObject doesn't provide all the options that I would like).
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 84
ID: 17139524
My apps use Codestone side-by-side with Outlook with no troubles. You should be fine with it.
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 200 total points
ID: 17150222
Did u look at redemption objects as well ?  http://www.dimastr.com/redemption/ it was in the link I gave earlier
0
 

Author Comment

by:schmir1
ID: 17272955
rockiroads
  Redemption looks very interesting.  I may also need it for another problem that I'm having - downloading our Outlook company address book (which as just stopped working recently).  I'll open another question when I get to that issue.

LSMConsulting:
  I think I would like to go Codestone in the future.  Right now I got my e-mail working using Microsoft's new SendObject source code.  Since they gave me the source, I'm feeling better about using it.

Thank both of you for your help.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17274423
No probs
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question