473,322 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

sending emails

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
8 2331
Set a reference to the CDO (Collaboration Data Objects)
library. For more info, www.slipstick.com.

Geoff
Nov 13 '05 #2
"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
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
"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
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
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
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

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: dan glenn | last post by:
I'm creating HTML emails from a PHP site and sending them out to an email list (just about 40 people so far are on this list). I've tested and confirmed that these emails work in yahoo.com's...
10
by: Stuart Mueller | last post by:
I have an exchange server, that I sometimes use to perform mail shots to clients on our database, these can be upwards of 1000 at a time. As we don't want different clients to see who we are...
1
by: Ian Taylor | last post by:
Hi all... Is it possible to send RTF-formatted emails using the .NET SmtpMail implementation? I can only find provision in the BodyFormat property of the message to send plain text or HTML...
3
by: VB Programmer | last post by:
My company has it's own webserver, which is going to host our ASP.NET web application. We want the website to be able to send out emails. 1. What do I need on the server so that it has the...
2
by: Mr. x | last post by:
Hello, I am sending emails with Hebrew contents. When receiving emails - I cannot see the Hebrew characters (it is not outlook express configuration, because when receiving emails from friends -...
3
by: Ant | last post by:
Hi, I'm using the MailMessage & smtpMail classes in System.Web.Mail to send mail, however it's not sending any emails. I'm using it on a Windows 2003 server. The simplest way to use this is...
5
by: Kun | last post by:
i have the following code: ---------------------------------- import smtplib from email.MIMEText import MIMEText fp = open('confirmation.txt', 'rb') msg = MIMEText(fp.read()) From =...
5
by: Jai | last post by:
Hi, I am in a problem of sending mass emails(newsletter) to my website members. Actually my problem is this: I want to send newsletter to my website members. But I had given a facility for...
1
by: robbiesmith79 | last post by:
Just so this is out there on the web, I battled the past 24 hours about this. Background info... I developed a ecommerce website in PHP 4 on a shared linux hosting plan from GoDaddy and had the...
2
by: lstanikmas | last post by:
Hi, I'm validating a form with this ASP but receiving some blank email responses; does anyone see anything wrong with it?: function isFormVarExcluded(thisForm, strToCheck) { var strExcludeVars...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.