Log in

View Full Version : Create Email list from mysql database



mcolton
06-26-2014, 08:34 PM
I have an existing database of members in my organization. I would like to be able to create an email list to I can send out a group email (in the Bcc:)
If someone could get me started in the right direction, I think I can finish it up.

I just updated a lot of my code from MySQL to PDO/php.

snakester
08-18-2014, 06:31 AM
As I use Coldfusion I cannot write your script for you but...

Seems to query db for email, name, etc as needed.

If you are going to use the list often you might want to create a table with just that data to keep the load down on your server.

Just loop through the query output into your email function.

nguyenhahuy
08-21-2014, 04:34 AM
Sub DSMTeam()

Dim myOlApp As Outlook.Application

Dim myItem As Outlook.MailItem

Dim myRecipient As Outlook.Recipient



Set myOlApp = CreateObject("Outlook.Application")

Set myItem = myOlApp.CreateItem(olMailItem)

myItem.Subject = "...."

myItem.Save



Set myRecipient = myItem.Recipients.Add("Email")

myItem.Subject = "HN1 - Daily Sales Report"

Set myAttachments = myItem.Attachments

myAttachments.Add "D:\

myItem.Send

giấy in nhiệt k80 (http://hanh.webchuyennghiep.net/giay-in-nhiet-k80.html)

nguyenhahuy
08-21-2014, 04:36 AM
code from outlook