Computing-Froggy
8 years ago
Hello

I am trying to use the EA component (EASendMailObjLib.Mail) from an MS-Access application (using VBA).

I've adapted the example from the doc to get a generic function to send e-mails (with the same interface I use for a function using CDO).
https://www.emailarchitect.net/easendmail/kb/vba_access.aspx?cat=0 

I can see from the messages in the status bar, that the process is connecting to the server and sends some data ... but it does not go till the end, it stops some where along the way. For instance I got :
Sending 1024 / 1551
or with an attached file :
Sending 61998 / 619967

If I use the CDO function I was using before, it still works with the same parameter (server, user, password).

I don't understand what's going on !
Any help would be appreciated.
ivan
  • ivan
  • 100% (Exalted)
  • Administration
8 years ago
Could you generate a log file with LogFileName property and send it to support@emailarchitect.net?

add this:

oSmtp.LogFileName = "d:\smtp.txt"

before

oSmtp.SendMail ...
Computing-Froggy
8 years ago
I've tried that before ... but nothing is generated !

From what I read in other threads, the log only gets generated when the process comes out of SendMail ... which it does not ! :(
ivan
  • ivan
  • 100% (Exalted)
  • Administration
8 years ago
could you contact us by support email address directly?
Computing-Froggy
8 years ago
Thanks to Ivan : problem solved.
It was a mistake on my part, renaming a variable in one part and not the other ... and not using "Option Explicit" : it's all good now.
I can send email via an Exchange SMTP server from Access: YOUPIE !

EXPLORE TUTORIALS

© All Rights Reserved, AIFEI Software Limited & AdminSystem Software Limited.