Send Object to send e-mail

  • Thread starter Thread starter Ceedy
  • Start date Start date
C

Ceedy

In Access 97, I have a field for e-mail address. If
filled in, the label turns blue telling the user they can
click on the label. When they do it brings up the Outlook
Express create mail form and adds the e-mail address to
the form. It works fine except the OE forms opens as a
Modal so if anyone needs to look at the access program or
copy & paste something they can't. Is there anyway to
change the OE form so it doesn't come up as Modal? Thanks
in advance for any help. Ceedy
 
Ceedy,

You may have a better chance of a good answer to your question in an OE
related newsgroup. For example, you could try...
microsoft.public.windows.inetexplorer.ie6_outlookexpress
 
Thanks for your response Steve. I did try the OE
newsgroup first. A Michael told me I shouldn't have a
problem and he was right as long as I load OE separately
and create a message but if I get that dialog box by using
SendObject, then it comes up in Modal form. Do you know
if there an OE group that knows about Access?
 
Ceedy,

Ah, ok, sorry you have been shunted around in a circle! As far as I
know, there is no waty to control this behaviour, not from within Access
anyway. You might need to come up with another way to handle this. Can
you let us know specifically what is your purpose in wanting to see the
Access window while the OE window is open?
 
Thanks again for your response Steve. Bottom line: I
have written an Access program for our company. We send
quite a few e-mails; some are pre-established messages and
some are free form. When someone clicks on the e-mail
label it brings up a form with 4 preset messages and one
free form. The preset messages aren't a problem because
they don't change but, of course, the free form message is
blank. Quite often someone starts a message then realizes
they need info from the Access program. That's where we
run into that Modal problem. I hope this make sense Steve.
P.S. Even if you can't help me with this problem it is
wonderful of you to help so many Access users. I have
learned so much just by reading your responses to other
peoples problems. You are a great man. Ceedy
 
Ceedy,

I think I understand what you are talking about, and if so, would this
work?... On your Access form that pops up with the messages, put a
large unbound textbox, into which the user can type their "free form"
message for the email, i.e. this is before the SendObject is called, and
then refer straight back to this textbox in the Message Text argument of
the SendObject macro, using synatx such as
[Forms]![NameOfForm]![NameOfTextbox]
 
Hello,
How did you format your e-mail address field, so that it turns blue???

Charles L. Phillips
 
Back
Top