+ Reply to Thread
Results 1 to 2 of 2

CDO Message help

  1. #1
    Registered User
    Join Date
    03-23-2018
    Location
    Atlanta
    MS-Off Ver
    Excel 2016
    Posts
    11

    CDO Message help

    I have a code that filters a column for unique entries. For each unique entry it will copy and paste the information into a new workbook and then it saves the file with an email address as the name. Then it should send that file as an attachment to the email address that the workbook was saved as. The code currently runs through for all unique values but will only email the first workbook. So for example if there were 6 unique values in the column, I would wind up with 6 saved files but only the first one is sent to the recipient. Any ideas on what needs to change in the code to get it to send to everyone? Any help is appreciated as I'm still fairly new to VBA.

    Please Login or Register  to view this content.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: CDO Message help

    This sounds more like excel than word? (you have posted in the Word forum)

    i will move it for you, PM me if I was wrong?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-30-2018, 12:17 PM
  2. Adding an input message to each cell to bring back corrsponding message
    By Nic31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2014, 09:28 AM
  3. [SOLVED] How to pop up a warning message before any Excel automatic update link reminder message
    By billj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2013, 10:41 AM
  4. Extracting mail message(outlook) table in the message body
    By andywsw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 10:14 PM
  5. need of pop up message dynamically using data validation input message method
    By vba_life in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2010, 09:03 AM
  6. Intercept/replace standard 'cell protected' message with my own message?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2006, 10:35 AM

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