+ Reply to Thread
Results 1 to 5 of 5

Email to address entered in cell using CDO

  1. #1
    Registered User
    Join Date
    06-25-2007
    Posts
    35

    Email to address entered in cell using CDO

    Hi

    This is probably simple but somehow I can't seem to get it to work!!!

    I have code which emails a workbook using CDO to an address hard coded in the macro. I now want to add an aditional address to the code. The additional address is entered in a cell of a worksheet before running the macro.

    The code at present looks like this:

    Please Login or Register  to view this content.
    I now want it to also send to the address contained in "uptime" worksheet cell "G4"

    Thanks Guys!!!!!!!!

  2. #2
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845
    Hi,

    Try setting the ".CC" to the worksheet range that has the email address.
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.

  3. #3
    Registered User
    Join Date
    06-25-2007
    Posts
    35

    Already tried

    Hi Charles

    Thanks for your response.
    I thought that was the solution myself but it doesn't work!!
    Any other ideas??

    Cheelie

  4. #4
    Forum Contributor
    Join Date
    12-11-2004
    MS-Off Ver
    2007
    Posts
    137
    Hello


    It's seems not possible to use multiple addressees with CDO method


    Regards
    michel

  5. #5
    Registered User
    Join Date
    06-25-2007
    Posts
    35
    I tried Charles' method (which I had tried before) and addressed it to 2 of my email addresses I use. The hardcoded address, whether it be "To" or "CC" is received but the address pulled from the cell is not. However both the emails which are delivered show the address from the cell as "To" or "CC" as if they had been sent!!!! Confused!!!
    Why is CDO not playing ball??
    I have to use CDO as not all personnel using the macro have email accounts set up on the PC's and I can't think of an alternative method to send.

    Thanks

    Cheelie

+ Reply to 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