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 8 2331
Set a reference to the CDO (Collaboration Data Objects)
library. For more info, www.slipstick.com.
Geoff
"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
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" <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
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
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" <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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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 -...
|
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...
|
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 =...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
|
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
|
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...
|
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...
| |