Email from form

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

In my database I have a form with a button starting
procedure of creating and sending an email message.
The database is installed on several computers. On all
computers the procedure works fine. But on one machine the
procedure runs only once (i.e. the first button click runs
the procedure and later clicks do not). The user has to
close the database and to open it again to send next
message and so on.
Where should I look for the problem - in Access or in
Outlook?
Thank you in advance!
 
I would put a break or Stop in the click event that run the Emailing
procedure, then step through to see if there is anything causing the line
not to execute. Make sure you don't have a Resume Next line before that.
It could be an error is being suppressed.

If the code steps through the necessary lines of code, it is likley Outlook,
especially if you are using the SendObject method.

Whenever I have an issue emailing though outlook it is something in the
Outlook configuration, usually that Outlook Express if the Default email
program. Sometimes that resets mysteriously. Check in IE Internet Options
in the Programs tab that Outlook is the default email program for that
computer.

God Bless,

Mark A. Sam
 
Back
Top