Closed Thread
Results 1 to 3 of 3

Sending Email by Selecting Names From a List

  1. #1
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Sending Email by Selecting Names From a List

    Hello VBA experts,
    I have attached a workbook with an example of what I need to do.
    I found the VBA code on this forum and am thankful to the writer.

    I have set it up such that when you click the "Send_Email" button, the VBA code reads the addresses in cells "J2" and "K2" and sends that worksheet to those addresses. It works well.

    Columns "J" and "L" will have a list of email addresses. I need to create an easy way for the user to select a few of those cells and send the email to all of them. One thought was to create some sort of check boxes or click buttons next to each address. Once the email is sent, all check marks would be cleared for next time around.

    The idea is to modify the code, so that it reads all addresses next to the check boxes and add them to the "To" and "CC" list.

    Any ideas, suggestions or solutions will be appreciated.

    Thanks,
    modytrane
    Attached Files Attached Files
    Last edited by modytrane; 11-19-2008 at 11:45 AM.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Send email by selecting from a list of names

    I hope someone ahs a suggestion or solution to this question.
    Any help will be appreciated.
    modytrane

  3. #3
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    please close this thrad !!!!!!

    Can one of the moderators, please close this thread?
    I never received any responses, so I did some more research and found some ideas elsewhere on this forum. I have started another thread looking for some help. The problem to be addressed in that thread is different than this thread.

    Thanks,
    modytrane

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1