sending emails

Set a reference to the CDO (Collaboration Data Objects)
library. For more info, www.slipstick.com.

Geoff

"WindAndWaves" <access@ngaru.com> wrote in message news:<DvePc.7914$N77.396974@news.xtra.co.nz>...[color=blue]
> Hi Gurus
>
> I am trying to send a newsletter from Access. Can anyone tell me what is
> the simplest way to send an email from Access? I would prefer not to use
> outlook, because this gives me all these security warnings and besides, I
> would prefer not to look outlook at all, so that people with Access RT could
> also use my code.
>
> Is there a way to send an email from DOS perhaps?
>
> TIA
>
> - Nicolaas[/color]

Nicolaas,
Have you looked at SendObject? that's assuming you're sending an
object that exists in your database though. Or are you sending to
addresses in your database? My guess is describe what you need better
and you'll get a better answer. Right now your question is something
like "Is this truck big enough to move all my stuff?" (Well, I don't
know. How much stuff do you have?)
Pieter

Dear Peter

It is actually very simple (an oxymoron in the MS world), I would like to
send an email using Access without any frills, security messages or what
have you. It seems like I already have a complicated solution (from the
Programmer's Guide to Internet Mail by John Rhoton), but if it could be any
simpler then that would be great.

TIA

- Nicolaas

"WindAndWaves" <access@ngaru.com> wrote:
[color=blue]
>I am trying to send a newsletter from Access. Can anyone tell me what is
>the simplest way to send an email from Access? I would prefer not to use
>outlook, because this gives me all these security warnings and besides, I
>would prefer not to look outlook at all, so that people with Access RT could
>also use my code.
>
>Is there a way to send an email from DOS perhaps?[/color]

BLAT is one method of sending via DOS. For a selection of alternatives see then
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

On Mon, 02 Aug 2004 05:52:43 GMT, Tony Toews <ttoews@telusplanet.net> wrote:
[color=blue]
>"WindAndWaves" <access@ngaru.com> wrote:
>[color=green]
>>I am trying to send a newsletter from Access. Can anyone tell me what is
>>the simplest way to send an email from Access? I would prefer not to use
>>outlook, because this gives me all these security warnings and besides, I
>>would prefer not to look outlook at all, so that people with Access RT could
>>also use my code.
>>
>>Is there a way to send an email from DOS perhaps?[/color]
>
>BLAT is one method of sending via DOS. For a selection of alternatives see then
>Microsoft Access Email FAQ
>http://www.granite.ab.ca/access/email.htm[/color]

Having use BLAT several times and having excellent luck with it, I highly
recommend it. A free tool that just does one thing simply and reliably

blat looks good, the only trouble is implementing it with all my clients
requires changes to their windows which I would like to avoid as much as
possible. I will look into it. Thank you all.

On Mon, 2 Aug 2004 18:12:38 +1200, "WindAndWaves" <access@ngaru.com> wrote:
[color=blue]
>blat looks good, the only trouble is implementing it with all my clients
>requires changes to their windows which I would like to avoid as much as
>possible. I will look into it. Thank you all.
>[/color]

What changes? If you the docs still say you need a DLL, that's old info, and
no longer true. You can just run the executable, and it works. Just pass all
the command line arguments you need, so you don't have to rely on registry
settings that might or might not be set up.

U¿ytkownik "WindAndWaves" <access@ngaru.com> napisa³ w wiadomo¶ci
news:DvePc.7914$N77.396974@news.xtra.co.nz...[color=blue]
> Hi Gurus
>
> I am trying to send a newsletter from Access. Can anyone tell me what is
> the simplest way to send an email from Access? I would prefer not to use
> outlook, because this gives me all these security warnings and besides, I
> would prefer not to look outlook at all, so that people with Access RT[/color]
could[color=blue]
> also use my code.
>
> Is there a way to send an email from DOS perhaps?
>
> TIA
>
> - Nicolaas
>
>[/color]

Look for a sample access db by Klaus Oberdalhoff at www.freeaccess.de -
named maildb.mdb or sth.

Pawel