Emailing from within MS Access

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"

Have you looked at the Access SendObject command?


"Greg" <lmandgj@dodo.com.au> wrote in message
news:404af707$1@news.comindico.com.au...[color=blue]
> 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"
>
>[/color]

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:thingo@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" <lmandgj@dodo.com.au> wrote in message
news:404af707$1@news.comindico.com.au...[color=blue]
> 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"
>
>[/color]

And, to add to the choices available to you for sending emails from an
Access database, there is Automation. Here are a few links:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm


--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"Greg" <lmandgj@dodo.com.au> wrote in message
news:404af707$1@news.comindico.com.au...[color=blue]
> 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"
>
>[/color]

Greg

Some good ideas already. Here's the caveats:

1. SendObject is buggered in Access 2000. Search the KB.

2. Any and all Outlook/CDO etc. automation will give you the security
prompts in anything past Outlook 2000 SR1. Which renders it pretty bloody
useless most of the time, as far as automation goes.

You have been warned.

Mike MacSween

"Greg" <lmandgj@dodo.com.au> wrote in message
news:404af707$1@news.comindico.com.au...[color=blue]
> 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"
>
>[/color]