Solved

Alternative to SendObject for Sending E-mail

Posted on 2006-07-17
7
647 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

803 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