> Before investigating this route, I would recommend
> exhausting attempts to fix your current method.  For
> example, I have used A97 to send emails that did not
> require user intervention.

> Could you please post the code that is offending?  If your
> real issue is additional user intervention, we can
> probably wiggle around that.

> --------------

> If, on the other hand, you are looking for a fully
> integrated email solution, I have one you could use.  I
> replied to another user who might need a custom non-MAPI
> solution, and I've copied the guts of it below --

> --------------

> I DO have a version that talks directly to an SMTP server,
> bypassing MAPI altogether (but doesn't have firewall
> support).  If you are interested in this version, email me

> My emailer was built as a stand-alone marketing tool for
> use with one of my contact databases.  The need was for
> the ability to send full-featured HTML emails, with merge
> fields replaced with data from the database.  For example,
> <<FullName>> was replaced with the contact's full name,
> pictures were embedded in the HTML document, and an Excel
> spreadsheet was sent along as an attachment.

> I have a VB stand-alone version, and a version that uses
> MS Word to build the file (VBA to execute it).  In the VB
> stand-alone, you build the HTML document you want to send
> and also the text-only version that is sent as well.  In
> the MS Word version, you build the HTML version using
> Word, and the VBA tells Word to save the document as a
> text file, and that is sent as the text-only version.  The
> VB-only version gives total control over the HTML and text-
> only versions, but the MS Word version is easier to use.

> I've included a kitchen sink with a hose sprayer in this
> emailer, and as a result I know more about SMTP and MIME
> than I ever wanted to (and I'm a curious kind of guy).

> Some of the specs:
> --Sends an HTML Version as well as a text-only version for
> lowbie email readers (like AOL *ahem*)

> --Ability to send multiple attachments

> --Uses a database table to supply email addresses

> --Uses the database table to replace strings within the
> document delimited with special character sequences (e.g.,
> << and >>).

> --Uses Windows sockets to communicate directly with an
> SMTP server

> --Builds a log of results

> --Uses base64 encoding and quoted-printable encoding.

> --Finds pictures within the HTML document, and
> automatically encodes and sends them with the email
> (base64 encoding with appropriate MIME delimiters)

> --Identifies pictures sent as links to www servers, and
> sends them as links (smaller email for faster download,
> receiver's email browser then downloads the linked picture)

> This emailer is not a toy.  Let me know if this is really
> what you need.

> David Atkins, MCP

> The short answer is: By connecting to the email server
> (e.g., mail.bellsouth.net) and speaking its language.

> I'll wrap my VB version into a COM object to make it
> easier to use.  We'll need to communicate by email, and
> I'll commit to having the COM object ready for Friday (the
> 14th).  I've wanted to wrap this code in COM for two
> years -- time to get it done!

> Just promise to post the result to the newsgroup to help
> others who many need it.

> David Atkins, MCP

>Your e-mailer sounds great !

>I didn't get very far trying to use Access directly. I
basically looked in
>the help and didn't find much expect the sendObject,

>How did you use A97 to send e-mails directly ?

>Basically, what I want to set-up is a system which, on a
daily basis
>verifies in my customer DB who has an appointment in X

>Any suggestions would be extremely helpful as I really

>Thanks for your help and time,

>Fred D'amico

>> The short answer is Yes, you can bypass Outlook and MAPI
>> altogether for that matter.

>> Before investigating this route, I would recommend
>> exhausting attempts to fix your current method.  For
>> example, I have used A97 to send emails that did not
>> require user intervention.

>> Could you please post the code that is offending?  If
your
>> real issue is additional user intervention, we can
>> probably wiggle around that.

>> --------------

>> If, on the other hand, you are looking for a fully
>> integrated email solution, I have one you could use.  I
>> replied to another user who might need a custom non-MAPI
>> solution, and I've copied the guts of it below --

>> --------------

>> I DO have a version that talks directly to an SMTP
server,
>> bypassing MAPI altogether (but doesn't have firewall
>> support).  If you are interested in this version, email
me

>> My emailer was built as a stand-alone marketing tool for
>> use with one of my contact databases.  The need was for
>> the ability to send full-featured HTML emails, with
merge
>> fields replaced with data from the database.  For
example,
>> <<FullName>> was replaced with the contact's full name,
>> pictures were embedded in the HTML document, and an
Excel
>> spreadsheet was sent along as an attachment.

>> I have a VB stand-alone version, and a version that uses
>> MS Word to build the file (VBA to execute it).  In the
VB
>> stand-alone, you build the HTML document you want to
send
>> and also the text-only version that is sent as well.  In
>> the MS Word version, you build the HTML version using
>> Word, and the VBA tells Word to save the document as a
>> text file, and that is sent as the text-only version.  
The
>> VB-only version gives total control over the HTML and
text-
>> only versions, but the MS Word version is easier to use.

>> I've included a kitchen sink with a hose sprayer in this
>> emailer, and as a result I know more about SMTP and MIME
>> than I ever wanted to (and I'm a curious kind of guy).

>> Some of the specs:
>> --Sends an HTML Version as well as a text-only version
for
>> lowbie email readers (like AOL *ahem*)

>> --Ability to send multiple attachments

>> --Uses a database table to supply email addresses

>> --Uses the database table to replace strings within the
>> document delimited with special character sequences
(e.g.,
>> << and >>).

>> --Uses Windows sockets to communicate directly with an
>> SMTP server

>> --Builds a log of results

>> --Uses base64 encoding and quoted-printable encoding.

>> --Finds pictures within the HTML document, and
>> automatically encodes and sends them with the email
>> (base64 encoding with appropriate MIME delimiters)

>> --Identifies pictures sent as links to www servers, and
>> sends them as links (smaller email for faster download,
>> receiver's email browser then downloads the linked
picture)

>> This emailer is not a toy.  Let me know if this is
really
>> what you need.

>> David Atkins, MCP

>.

> Thanks for the help !

> I would be more than happy to share information here to help others, just
as
> you are generously help me !

> Thanks again,

> Fred

> > "How did you use A97 to send e-mails directly ?"

> > The short answer is: By connecting to the email server
> > (e.g., mail.bellsouth.net) and speaking its language.

> > I'll wrap my VB version into a COM object to make it
> > easier to use.  We'll need to communicate by email, and
> > I'll commit to having the COM object ready for Friday (the
> > 14th).  I've wanted to wrap this code in COM for two
> > years -- time to get it done!

> > Just promise to post the result to the newsgroup to help
> > others who many need it.

> > David Atkins, MCP