Solved

Alternative to SendObject for Sending E-mail

Posted on 2006-07-17
7
652 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

738 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