Link to home
Start Free TrialLog in
Avatar of schmir1
schmir1Flag for United States of America

asked on

Alternative to SendObject for Sending E-mail

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.
Avatar of rockiroads
rockiroads
Flag of United States of America image

Alternatives - Outlook Automation or CDO (Collaboration Data Objects)

CDO uses Exchange so u dont get the security message

See my sample code here
https://www.experts-exchange.com/questions/21866975/How-do-I-get-Access-to-send-an-email-with-a-txt-file-attached-without-user-intervention.html

And see this regarding outlook security popup
https://www.experts-exchange.com/questions/21904604/Auto-Email-Query-from-Access.html
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of schmir1

ASKER

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).
My apps use Codestone side-by-side with Outlook with no troubles. You should be fine with it.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of schmir1

ASKER

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.
No probs