Solved

Alternative to SendObject for Sending E-mail

Posted on 2006-07-17
7
646 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now