Results 1 to 4 of 4

Thread: Create Email list from mysql database

  1. #1
    Join Date
    May 2009
    Location
    Greensboro, GA
    Posts
    163
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Default Create Email list from mysql database

    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.

  2. #2
    Join Date
    Jun 2014
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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.

  3. #3
    Join Date
    Aug 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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

  4. #4
    Join Date
    Aug 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    code from outlook

Similar Threads

  1. How do I Create a database
    By babasho in forum MySQL and other databases
    Replies: 2
    Last Post: 01-02-2011, 08:04 PM
  2. Replies: 1
    Last Post: 10-20-2010, 06:18 AM
  3. How do I create a MySQL Database?
    By 5starmember in forum MySQL and other databases
    Replies: 10
    Last Post: 10-04-2008, 03:18 PM
  4. Form that Create account for visitors (PHP Mysql Database)
    By akluch2 in forum MySQL and other databases
    Replies: 5
    Last Post: 02-11-2008, 02:01 PM
  5. How can I create a two column list?
    By pernes in forum CSS
    Replies: 1
    Last Post: 09-01-2006, 09:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •