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
Powered by vBulletin® Version 4.2.2 Copyright © 2021 vBulletin Solutions, Inc. All rights reserved.