+ Reply to Thread
Results 1 to 11 of 11

Checking Mail IDS

  1. #1
    Forum Contributor
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    100

    Checking Mail IDS

    Hi friends,

    I got the below code from this forum. The below code checks the TO field if it matches it will send the mail.

    I want to check CC field also am tried to edit the code. But its not working. Could you please advice how to check the CC field also and two add two mail ids in the exception list.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    100

    Re: Checking Mail IDS

    I have now made a check to CC field also. Just need to add two mail ids in the exception list please help

  3. #3
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Checking Mail IDS

    Perhaps you want to check other addresses this:

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    To mark "Solved" go to Thread Tools.

  4. #4
    Forum Contributor
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    100

    Re: Checking Mail IDS

    Its Not working skatonni. While sending invoice we used to mark our manager mail id. Since manager ID wont match with the company name am unable to add the mail id while sending. please help

  5. #5
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Checking Mail IDS

    I can suggest Debug.print recip.name to see what "manager mail id" actually is.

    If that does not solve the issue show the code you are using.

  6. #6
    Forum Contributor
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    100

    Re: Checking Mail IDS

    Hi Skatooni,

    My issue here was to include my manger mail id in the exception list. Reason is my manager id is [email protected], the initial code checks the subject since the manager id is different from the subject name the code does not allow to send the mail.

    I have tried the above code u have provided but its not working.

  7. #7
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Checking Mail IDS

    I finally figured out there was an Exit Sub instead of a cancel. Not a problem before you wanted to check more than one address.

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    100

    Re: Checking Mail IDS

    Skatooni still its not working. This was the code am using, I modified from the initial one you provided

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Checking Mail IDS

    You make clname the same as lname.
    Please Login or Register  to view this content.
    So later you are checking the manager's company name against the external company name.

    If you are using "[email protected]" to test the code then the manager's company name is test.

    Try
    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    100

    Re: Checking Mail IDS

    Still am not getting skatonni. Please share the code

  11. #11
    Forum Contributor
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    100

    Re: Checking Mail IDS

    Got it. Thanks all for ur help.

    Please Login or Register  to view this content.

+ 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. [SOLVED] screenshot text file and embed in outlook mail through excel with mail info
    By bmbalamurali in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-11-2015, 08:21 PM
  2. Mail variable number of sheets in workbook based on VLOOKUP mail address
    By Tino XXL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2013, 08:44 AM
  3. code to attach the draft mail in new compose mail as attachment in outlook 2010
    By priya1987 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 08:38 AM
  4. Checking Outlook E-mail before sending through Excel
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2012, 04:57 AM
  5. How to e-mail selected row and use e-mail address in a cell to send e-mail from excel
    By syedalamgir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2010, 02:15 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