By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,589 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,589 IT Pros & Developers. It's quick & easy.

sending emails

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


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

Geoff
Nov 13 '05 #2

P: n/a
"WindAndWaves" <ac****@ngaru.com> wrote in message news:<Dv*******************@news.xtra.co.nz>...
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


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
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
"WindAndWaves" <ac****@ngaru.com> wrote:
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?


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
Nov 13 '05 #5

P: n/a
On Mon, 02 Aug 2004 05:52:43 GMT, Tony Toews <tt****@telusplanet.net> wrote:
"WindAndWaves" <ac****@ngaru.com> wrote:
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?


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


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
Nov 13 '05 #6

P: n/a
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.
Nov 13 '05 #7

P: n/a
On Mon, 2 Aug 2004 18:12:38 +1200, "WindAndWaves" <ac****@ngaru.com> wrote:
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.


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.
Nov 13 '05 #8

P: n/a

Użytkownik "WindAndWaves" <ac****@ngaru.com> napisał w wiadomo¶ci
news:Dv*******************@news.xtra.co.nz...
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


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

Pawel


Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.