Email Options in Acc 2000 SendObject vs CDONTS.DLL

[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

 

[Dan Artuso]

Hi,
You can use the OutputTo method to create a snapshot file.

 

[Don]

Dan:

Can you point me to an Example of how to do this?

Many Thanks,

Don

-----Original Message-----
Hi,
You can use the OutputTo method to create a snapshot file.

--
HTH
Dan Artuso, Access MVP


"Donald Regener" <[email protected]>

wrote in message [email protected]...

 

[Don:]

Dan:

I have looked at the OutputTo Action from MS Access Help.

It does not show using a .snp extension. I am trying to
use a MS Access Report. I want it to go out as a .snp
file.

Thanks in advance,

Don

 

[Dan Artuso]

Here's a snippet from help:
OutputFormat Optional Variant. The output format, expressed as an AcFormat constant. If you omit this argument, Microsoft Access
prompts you for the output format.

AcFormat can be one of these AcFormat constants.
acFormatASP
acFormatDAP
acFormatHTML
acFormatIIS
acFormatRTF
acFormatSNP
acFormatTXT
acFormatXLS

you want the acFormatSNP format

 

[Don Regener]

Dan:

I can take it from here. Appreciate your help.

Thanks,

Don

-----Original Message-----
Here's a snippet from help:
OutputFormat Optional Variant. The output format,

expressed as an AcFormat constant. If you omit this
argument, Microsoft Access

prompts you for the output format.

AcFormat can be one of these AcFormat constants.
acFormatASP
acFormatDAP
acFormatHTML
acFormatIIS
acFormatRTF
acFormatSNP
acFormatTXT
acFormatXLS

you want the acFormatSNP format
--
HTH
Dan Artuso, Access MVP


"Don:" <[email protected]> wrote in

message news:[email protected]...