D
Donald Regener
I am using MS Access 2000 to Construct and Send Email.
The Email Body includes data taken from an Open Form. I
also require a .snp Attachment that uses data from the
same open form. The Data Source (Open Form) will
eventually be changed to a RecordSet for both the Email
Body and the Email .snp Attachment.
I have two solutions at the current time: (1) SendObject
Method & (2) CDONTS.DLL.
The SendObject Method is failing unpredictably as
discussed in MS Article Q260819, But I am able to generate
the required .snp attachment. The Program fails by only
sending one message and then requires rebooting the Access
Application BEFORE I can send another one. I cleared
problem by making the Subject Line and Body smaller than
desired. The subject line is too small to meet the
application requirements.
I am able to send a much larger body, Subject Line, and
various Addresses (To, Bcc, Cc) with no problems. The
problem is how to generate (with code) the required .snp
File. I was able to generate the file using SendObject,
but the file was not generated as a "Real File", with a
Path Statement for other uses. CDONTS.DLL requires a Path
Statement to a "Real File" in order to send as an
attachment.
I am basically asking for two things:
(1) How can I generate (Using VBA Code) a MS Access Report
as a .snp File with a Path to Find & Use it with
CDONTS.DLL?
(2) An opinion as to SendObject vs CDONTS.DLL.
SendObject has a much nicer User Interface including
saving a copy of the Out Going message and indication the
message was sent. It is not very reliable and much is
written regarding how Outlook Security is having a greater
impact in the future.
CDONTS.DLL is used with my current operating system ...
Win 2000. There is an upgraded version with Win XP ...
CDOSYS.DLL. It appears to be more stable and there is
an "Advancement Path" with the Newer Operating System. If
I can solve the Access Report as a .snp Attachment
problem, which method is preferred? ... SendObject or
CDONTS.DLL???
Thanks in advance for your help.
Don
The Email Body includes data taken from an Open Form. I
also require a .snp Attachment that uses data from the
same open form. The Data Source (Open Form) will
eventually be changed to a RecordSet for both the Email
Body and the Email .snp Attachment.
I have two solutions at the current time: (1) SendObject
Method & (2) CDONTS.DLL.
The SendObject Method is failing unpredictably as
discussed in MS Article Q260819, But I am able to generate
the required .snp attachment. The Program fails by only
sending one message and then requires rebooting the Access
Application BEFORE I can send another one. I cleared
problem by making the Subject Line and Body smaller than
desired. The subject line is too small to meet the
application requirements.
I am able to send a much larger body, Subject Line, and
various Addresses (To, Bcc, Cc) with no problems. The
problem is how to generate (with code) the required .snp
File. I was able to generate the file using SendObject,
but the file was not generated as a "Real File", with a
Path Statement for other uses. CDONTS.DLL requires a Path
Statement to a "Real File" in order to send as an
attachment.
I am basically asking for two things:
(1) How can I generate (Using VBA Code) a MS Access Report
as a .snp File with a Path to Find & Use it with
CDONTS.DLL?
(2) An opinion as to SendObject vs CDONTS.DLL.
SendObject has a much nicer User Interface including
saving a copy of the Out Going message and indication the
message was sent. It is not very reliable and much is
written regarding how Outlook Security is having a greater
impact in the future.
CDONTS.DLL is used with my current operating system ...
Win 2000. There is an upgraded version with Win XP ...
CDOSYS.DLL. It appears to be more stable and there is
an "Advancement Path" with the Newer Operating System. If
I can solve the Access Report as a .snp Attachment
problem, which method is preferred? ... SendObject or
CDONTS.DLL???
Thanks in advance for your help.
Don