Re: Access 97 - Sending an Email with Content using a Command ***

Hi Rob,

I agree with you here, but I have made this work with Novell Groupwise,
Lotus Notes, et al... and even Outlook!
All proprietary email programs...

Pete

"Rob Parker" <NOSPAMrobpparker@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OtnRnOZWHHA.5060@xxxxxxxxxxxxxxxxxxxxxxx
Hi Joe,

I strongly suspect that DoCmd.SendObject will not work with Hotmail (or
gmail, or Yahoo mail), since that is not an email program per se; it
(they) are web-based mail services. It might well work with other email
clients such as Thunderbird, Eudora, Pegasus, etc.

I've never used Lotus Notes, so I can't comment on whether that might be
the source of your problem.

Rob


"Joe Coulter" <JoeCoulter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C5EDB5E-18AF-49D6-89B2-1561F08BAD35@xxxxxxxxxxxxxxxx
Hi Rob

Again, thanks for your reply, I am using Lotus Notes which was open at
the
time, therefore Access 97 must have a problem recognising this email
software,if the code I tried works with outlook, it will probably work
with
most others, I will try some more tests, such as with Hotmail etc, If I
can
get it to work with most popular email software, that will have to do.

Thanks for your help with this, It was greatly appreciated.

Joe

"Rob Parker" wrote:

Hi Joe,

The line you posted works fine for me (when I change TBL_MAIN to the
name of
an actual table). I get an email message with an Excel spread***
attachment (tblName.xls), and the To:, cc:, and Subject: fields as
expected,
ready to be sent.

I've not come across the error message you've found, but from the
description I think Access is unable to find your email program. Are
you
using Outlook or Outlook Express (I know there is no problem with either
of
those), or something else? If it's something else, was the email
program
open at the time?

Other than that, I'm at a loss for suggestions. If it's a problem with
another email program, I suggest you post a new question with details of
that.

HTH,

Rob

"Joe Coulter" <JoeCoulter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:62ABE1A4-BB66-4536-88AD-A2A0DC10047B@xxxxxxxxxxxxxxxx
Rob

Thanks for you reply, I tried the following to send the table
"TBL_MAIN"
in
XL format to Nancy Davolio and cc to Joan Weber with the subject being
"New
Data Table"

DoCmd.SendObject acSendTable, "TBL_MAIN", acFormatXLS, "Nancy
Davolio",
"Joan Weber", , "New Data Table"

This has returned the run time error 2287, "Microsoft Access cannot
open
the
mail session"

Any suggestions would be appreciated.

Thanks

Joe



"Rob Parker" wrote:

Check out the SendObject method in the help file. It allows you to
set
several parameters (including cc: and subject: fields), and send any
of
several objects (query, report, table, ...) as an attachment, in
various
formats.

HTH,

Rob

"Joe Coulter" <JoeCoulter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:18635022-6948-406F-A8AC-43A82B01EE24@xxxxxxxxxxxxxxxx
I have a database that is used to log details about received
materials,
when
a new receipt is entered, I want some of the record detail sent to
a
choosen
person via the users email when a button is clicked

I currently have a command button "eMail_Btn" with the following in
the
"On
Click" Event - Application.FollowHyperlink "mailto:"; &
Me.EMailAddress.Value
EMailAddress being the field on the input form to choose the email
address
to send.

This works fine, but only Opens the email software and populates
the To
section with the selected email address, but what I also need to do
is
also
populate the CC, Subject and include two or three pieces of
information
within the body of the email with data also taken from fields
within
the
input form and automatically send the email.

I have been doing this with another system that emails to Lotus
Notes
from
Lotus Notes, but I now need to be able to change this to use any
email
software.

I appreciate any help offered.

Joe










.