Hi Greg,
Have a look at using a hyperlink. I've got a favourite trick: add a label
to a form and give it a meaningful name (lblEmail for example); select the
label, then using the menu Insert, Hyperlink, select Email Address in the
next dialog. If you will always be sending the same email, then just fill
it in. If not, then use the Form_Current event to update the labels'
hyperlink properties with whatever you need through VBA (i.e. if the form's
underlying RecordSource happens to have an email address field, then use
that to update the label's hyperlink to, for instance,
mailto:th****@somewhere.com). Have a look in the Access/VBA help files for
your options.
What you end up with is a label that looks like a hyperlink (underlined
blue) that will fire up an email when the user clicks on it. Once you've
got this one down, it's so simple to use.
HTH
Andrew
"Greg" <lm*****@dodo.com.au> wrote in message
news:40********@news.comindico.com.au...
Can any one point me in the right direction.
I want to be able to , with in MS Access , send a email using OUTLOOK.
In other words , have a button on a menu that i click on which starts up
Outlook and fills in subject or body with pre defined text.
Can any one help?
thanks
--
"Scanned with Nortons Antivirus 2004"