Results 1 to 3 of 3

Thread: Send email from Excel custom list using outlook

  1. #1
    Junior Member
    Join Date
    Jul 2011
    Posts
    19
    Rep Power
    0

    Send email from Excel custom list using outlook

    Dear All,
    I would like to develop a master file to send automated mail with the capabilities as mentioned below.

    1. Pick the file (Macro enabled report file) from a specific folder and send to each client as mentioned email id
    2. Email ids and Client details are mapped in the second sheet - "Email List"
    3. Email Client list may go up to 600 Nos.
    4. Custom message for each client is required.


    I tried with some macro available in the net. But somehow it is not working.

    Kindly help


    Regards,
    Leo Paul
    Attached Files Attached Files

  2. #2
    Junior Member
    Join Date
    Jul 2011
    Posts
    19
    Rep Power
    0

    Cool

    Quote Originally Posted by leopaulc View Post
    Dear All,
    I would like to develop a master file to send automated mail with the capabilities as mentioned below.

    1. Pick the file (Macro enabled report file) from a specific folder and send to each client as mentioned email id
    2. Email ids and Client details are mapped in the second sheet - "Email List"
    3. Email Client list may go up to 600 Nos.
    4. Custom message for each client is required.


    I tried with some macro available in the net. But somehow it is not working.

    Kindly help


    Regards,
    Leo Paul



    Dear Administrator,

    The solution worked well with the earlier threads.

    Thank you... for creating a wonderful support

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Glad you sorted out yourself with the help of other posts !
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Replies: 12
    Last Post: 12-10-2019, 09:56 PM
  2. Replies: 2
    Last Post: 06-12-2016, 12:49 AM
  3. Replies: 2
    Last Post: 05-23-2013, 08:08 AM
  4. How To Send Outlook Email Using VBA
    By mfaisalrazzak in forum Excel Help
    Replies: 7
    Last Post: 03-03-2013, 03:09 AM
  5. Send Outlook Email With Word Document
    By Murali K in forum Excel Help
    Replies: 2
    Last Post: 06-27-2012, 08:42 PM

Posting Permissions

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