473,410 Members | 1,908 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,410 software developers and data experts.

Batching emails :: aspEmail vs CDO :; sendQueue stability?

Database: Access 2000
Host: Maximum ASP

I am trying to work out the best way to send bulk email below the 1000 mark
(about 800).

I understand that I could either use ASPEmail or CDO although I believe that
ASPEmail may be superior in that it offers SENDQUEUE command which will
allow me to loop through my customer database and insert them into the TO
fields.

1. Could the above be confirmed?
2. I wish my mailing list to be invisible - I don't want the mailing list to
be evident in the recipients email...is this just a question of looping them
into the BCC field?
3. I remember seeing some posts a while ago highlighting problems with the
SendQueue Method.... what are the curve balls with this approach.

My web host tells me I can send upto a 1000 per day yet www.aspfaq.com says
about 800. How do I tackle this task correclty. I cannot move up to SQL
Server or MSDE yet and I do not have access to a mail server...

Many thanks
Jason
Jul 19 '05 #1
2 3348

Thanks for feedback...

Does your host have the SendToQueue option installed? You need to check
that first.

Yes, this has been confirmed for ASPEMAIL, although I still need to find out
if CDO offers this too and whether this would be better? Which wins -
aspemail or cdo? I normally use Cdo but I'm prepared to go for aspmail to
get job done.

Here's what I would do for BCC, this way the recipients do not see
eachother. Just make sure that the AddAddress is a valid address in your
organization:
This is don't understand. What do you mean by AddAddress must be valid to
your organization...could you elaborate?
Mail.AddAddress "ma*********@example.com", "Example Mailing List"
Mail.AddBcc MailingRs("email") MailingRs("recipient_name")

Mail.Subject "Here is a great subject"
Mail.Body "Here is the body of the message"
Mail.SendToQueue
Wow, is it really as easy as this.....is there any other constraints you
need to place on the script....I mean, how do you know:

- If the script executes correctly -
- What errors are normally thrown up if the recipients address is invalid or
their inbox is full...what are best practices?
- How long will it take to send out eg: 800 emails
- Is there any further steps I need to do to break up the emails?

- Jason
--
Adrienne Boswell
Please respond to the group so others can share
http://www.arbpen.com

Jul 19 '05 #2
Gazing into my crystal ball I observed "jason" <ja***@catamaranco.com>
writing in news:ur**************@TK2MSFTNGP09.phx.gbl:

Thanks for feedback...

Does your host have the SendToQueue option installed? You need to
check that first.

Yes, this has been confirmed for ASPEMAIL, although I still need to
find out if CDO offers this too and whether this would be better? Which
wins - aspemail or cdo? I normally use Cdo but I'm prepared to go for
aspmail to get job done.

Here's what I would do for BCC, this way the recipients do not see
eachother. Just make sure that the AddAddress is a valid address in
your organization:


This is don't understand. What do you mean by AddAddress must be valid
to your organization...could you elaborate?


When I send a bunch of BCC messages, instead of having the To: address one
of the recipients, I usually use myself. The old Netscape mail client was
able to send BCC without a To address. I don't know if Aspemail is able to
do this or not, therefore the suggestion that you use a valid email address
in your organization. Mail.Address is Aspemail's version of To:
Mail.AddAddress "ma*********@example.com", "Example Mailing List"
Mail.AddBcc MailingRs("email") MailingRs("recipient_name")

Mail.Subject "Here is a great subject"
Mail.Body "Here is the body of the message"
Mail.SendToQueue
Wow, is it really as easy as this.....is there any other constraints
you need to place on the script....I mean, how do you know:

- If the script executes correctly -


If Err <> 0 Then
Response.Write "An error occurred: " & Err.Description
End If
- What errors are normally thrown up if the recipients address is
invalid or their inbox is full...what are best practices?
You'll get returned mail from the recipients mail server. It goes without
saying that you need to clean your list of undeliverables. You might want
to think about making another table that has Inbox Full, or Vacation
responses, as those are probably good addresses and could be tried on
another mailing.
- How long will it take to send out eg: 800 emails
It depends on what the server is doing, if it has tasks to complete, etc.
If I were you, I would try to send the mail in the evening.
- Is there any further steps I need to do to break up the emails?


Check your spelling, punctuation and grammar. I'm serious when I say this,
because there is nothing more unprofessional looking than misspellings and
bad grammar. Send a message to someone you know, and ask them to proofread
it before you send it out to your mailinglist.

--
Adrienne Boswell
Please respond to the group so others can share
http://www.arbpen.com
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: jason | last post by:
If you are sending out bulk emails in the range of 800 to 1000 per day which component is better: 1. ASPEmail 2. CDO ....and further, do they also BOTH use a SEND TO QUEUE option. I wish...
0
by: Chuck | last post by:
Hi! I have created an ASP page that calls a webservice using an XSL page. The data is displayed correctly in the table. I added a submit button. When I invoke the button an email is sent to me...
15
by: news.microsoft.com | last post by:
HI, ASPEmail to send to multiple recipients? I tried to use comma and semicolon but all the time give this message error: Error: 6 - 501 Bad address syntax nor :...
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...
0
by: Yuancai \(Charlie\) Ye | last post by:
Hi, All: I am happy to annouce that we have formally released our latest SocketPro version 4 at www.udaparts.com, an advanced remoting framework written from batching/queue, asynchrony and...
0
by: usenet | last post by:
Hi. I have a DB2 stored procedure that I call using JDBC. Now I'm trying to batch the call. This is done by the book: stmt = connection.prepareCall(" ... "); stmt.setString(1, "foo");...
1
by: JohnDoe | last post by:
I am trying to find a sample coding in VB on how to setup a simple button that will do a mass email from a table within Access 2000. I want to be able to click a button and Access opens up my...
1
by: Andrew Wrigley | last post by:
Hi I am setting up emailing for an all Access contact management app and DO NOT want to use Outlook. Aspemail.dll (aspemail.com) works fine, but... Unless you pay the licence fee for the...
12
by: Dave G | last post by:
Apologies if this has been covered before - I couldn't find it. I currently use ASPEmail to create and send HTML emails from an Access database. The text is personalised and includes embedded...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.