Using email in Access

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

I have this form in Access that sends an email
confirmation after the user clicks on the submit button.
Anyway, when the email is sent it is saved in the sent
items folder in outlook. Is there a way to make it so
that the email sent isn't saved in the sent items folder?
 
The setting is within the email program not to save sent email. However,
turning this off, will not save any email sent. I don't believe you can code
something to override this within Access.
 
I believe GVaught is correct but, you may not have to use Outlook or any
other email client to send mail from your access app.

If all of your clients are running Win2k or higher you can use CDO to send
email without involving the users email app at all. The down side of this
is you will need to know the name or IP address of each users SMTP server,
and possibly their username and password if their SMTP server requires
authentication before accepting mail. In the corporate world this is
usually pretty easy as you can just pick one of your email servers and be
done with it. If you app is distributed to a more diverse population you
will have to devise a method of storing this information in a UserPrefs
table or the registry.

Look at the thread in this group "Emailing from Access" for some sample code
you may be able to adapt.

Ron W
 
Back
Top