Request for Tom Wickerath

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

Tom, you recently helped me out with your Sendmail function (written 7 May
2006). It works just fine with one minor issue.

If Outlook is closed when I call the routine, an Outlook dialog box opens
warning that a program is generating a message. This is fine.

If Outlook is open, the same message box appears which is fine, but the
focus changes to Outlook and remains there even after acknowledging the
message. Is there anything can be done about this? I don't necessarily want
to close Outlook, just shift the focus back to Access.

Whether you can help with this or not, thank you very much for the function.
 
Hi Ian,

I don't know of a way of automatically shifting the focus back to Access.
The modal dialog box is presented by Outlook for your approval, so Outlook
has the focus at that point. If this issue causes too much pain, then perhaps
you need to look at an alternate method of sending e-mail from Access. Here
are two possibilities, although I don't know if you would experience the same
focus issue:

Worldcast by Fairlogic
http://www.fairlogic.com/worldcast/

Total Access Emailer
http://www.fmsinc.com/products/Emailer/index.asp

or possibly this?
http://www.contextmagic.com/express-clickyes/


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Thanks for the suggestions, Tom. I think we'll live with it as it is.

A brief galnce at your suggestions leaves me with the distinct impression
that all of them involve downloading/installing extra software. As the
database I'm working with is a cut-down version of our main service database
designed to be held on each engineer's laptop, it's very likely that this
will cause issues when we distribute it (ie having to install the software
on each laptop).

Thank you very much for your help.
 
Tom Wickerath said:
If this issue causes too much pain, then perhaps
you need to look at an alternate method of sending e-mail from Access. Here
are two possibilities,
Click to expand...

Also Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
yeah these dipshits don't even mention XP_SENDMAIL

using a real database like 'Access Data Projects w/SQL Server' allows
you to deliver a SECURE email application.

dropping your pants on every desktop by allowing CDO and outlook
automation / security = LOW?

JUST NOT RECCOMENDED

lose the training wheesl you MDB newbies; ADP is 100 times better
 
I've discovered that, now I'm calling the code from a button, rather than
direct in the module, Outlook doesn't take the focus. Problem solved.
 
Back
Top