"Allowing" Access to email report

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I am tinkering with the SendObject command in order to
have Access email a report object. Everthing works
brillantly as long as I have my Outlook application open
on my PC at same time as the Access application. When
Outlook is closed and I try to execute the SendObject
command a "Choose Profile" dialog box comes up. I have to
click an "OK" button in order for the email to go
through. It is as though Access "doesn't know" something
that it needs to know about sending to email addresses.
The help for SendObject seems to assume that it will work
without any special "integration" of Access with Outlook.

I am looking for some general advice on how to diagnose
this further. Basically I do not want the
intermittent "Choose Profile" dialog box to appear, but
rather have the SendObject command simply send the report
object to the email address.

Any thoughts or advice would be greatly appreciated.
 
If you are comfortable doing a little coding, you can
manipulate Outlook from a code window in Access. You can
create an Outlook Application Object that will eliminate
the need for you to have outlook open on your pc. Check
out knowledge base article 291120 "OL2002: How to Automate
Outlook from Another Program". As long as you have not
installed the Outlook Email Security Update, you won't
have message boxes poping up.
 
Back
Top