Hi..
My job requires me to send frequent notification to different group of customers periodically.
I have a table that stores email addresses (EmailAdd) that are grouped by categories (CAT).
How can I create a script that will send email notifications based on an input form where CAT and notification text [TEXT] are keyed in?
I have tried to search the forum but could not locate similar topic on this.
Appreciate if anyone could offer their help.
Cheers!
Clarence
7 2588
Hi..
My job requires me to send frequent notification to different group of customers periodically.
I have a table that stores email addresses (EmailAdd) that are grouped by categories (CAT).
How can I create a script that will send email notifications based on an input form where CAT and notification text [TEXT] are keyed in?
I have tried to search the forum but could not locate similar topic on this.
Appreciate if anyone could offer their help.
Cheers!
Clarence
One method for you to consider is this create a listbox of your relevant categories that has a multi select feature to it. The idea being that whatever you multi select in that list box returns in another listbox, a list of email addresses related to the first list of multi selected (potentially)categories.
This second list of email addresses should also be multi select. The idea being that you could then multi select one or more email addresses. Having made your selection from the email address list you then type into an unbound text box your message click a button and send the mail. Is this what you want? (am not going to code the example of this if its not what you had in mind) if it is....then post your table structure ie table and fieldnames and we'll make it fit that
Regards
Jim :)
Hi Jim,
Thanks for your reply.
In fact, I would not need to select email addresses once I have chosen the category.
The form should send emails based on the category I have selected.
The flow should be, select the category, type in the notification text and click on the SEND button. The form should send to all email addresses belonged to the CAT I have selected.
Regards,
Clarence
Hi Jim,
Thanks for your reply.
In fact, I would not need to select email addresses once I have chosen the category.
The form should send emails based on the category I have selected.
The flow should be, select the category, type in the notification text and click on the SEND button. The form should send to all email addresses belonged to the CAT I have selected.
Regards,
Clarence
Clarence,
Post your table structure (name,fieldnames) and I'll see what I can do
Jim
Clarence,
Post your table structure (name,fieldnames) and I'll see what I can do
Jim
Hi Jim,
I do not know how to attach a file here.
My table name is Email and the field names are EmailAdd (email addresses) and CAT (category).
Please let me know if this is what you have requested.
Regards,
Clarence
Hi Jim,
I do not know how to attach a file here.
My table name is Email and the field names are EmailAdd (email addresses) and CAT (category).
Please let me know if this is what you have requested.
Regards,
Clarence
Hi Clarence,
A database is attached that demonstrates concatenating a list of email address together separated by a semi colon. These emails are derived from your table. The send method is by using Access DoCmd.Sendobject method (without actually sending an object)
If you place valid data ie email addresses in the tables it should work
Regards
Jim
Hi Jimmy,
Your sample database works perfectly for me!!!
Thank you so much!
Cheers
Clarence
Hi Jimmy,
Your sample database works perfectly for me!!!
Thank you so much!
Cheers
Clarence
You're welcome and thankyou for posting back
Jim :)
Sign in to post your reply or Sign up for a free account.
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: 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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |