Thank you for the link. Unfortunately, it won't work for me, because
not all of my users have Outlook. Some have other email programs. So
that is why I use the Send Object command, since it will launch
whatever their default mail program happens to be. Any other
suggestions? Anyone?
What you ask simply isn't possible using SendObject.
So you will need to find code to match each of your users software.
There are other software links at the Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm such as Novell Groupwise and
Lotus Notes.
Also you'll want to use late binding instead of a reference as your
users may have different versions of Outlook or the code will only
error out once you attempt to use Outlook. If you leave a reference
to Outlook or other software your code will start doing very
interesting things when installed at your users. If it runs at all
past the first form or two.
Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.
This also is very useful when you don't know version of the external
application will reside on the target system. Or if your organization
is in the middle of moving from one version to another.
For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.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
Tony's Microsoft Access Blog -
http://msmvps.com/blogs/access/