+ Reply to Thread
Results 1 to 4 of 4

Issue resolving recipients

  1. #1
    Registered User
    Join Date
    06-06-2017
    Location
    Illinois
    MS-Off Ver
    Excel 2016
    Posts
    25

    Issue resolving recipients

    First off, if this is in the wrong place I'm sorry. I'm writing the macro in Excel, but ultimately it's for Outlook. If it should be moved somewhere else, please have it moved!

    I'm working on a macro to send out e-mails based off of an excel sheet. However, I'm running into an interesting problem. When using contact groups, everything works fine. If, however, I'm trying to use individual e-mail addresses in the "to" field, Outlook will not resolve them via VBA. It doesn't seem to matter if I have the e-mail address added as a contact or not. If I leave the e-mail open for a minute, it'll resolve them automatically without issue. That's not really a valid solution though, seeing as how there will often be 200+ e-mails sent out with this macro. Also, I can't just make contact groups for all of these, as that will quickly add up to over 10,000+ groups.

    I know the explanation is kind of weak, but I'm not too sure what else to say just yet. I'll paste the portion of the code below in case it's helpful to anyone. If anyone has any suggestions on what else I can try, or any questions to make things clearer for you, let me know. Thank you all!!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,107

    Re: Issue resolving recipients

    .
    Hmmm ... you speak of Contact Groups and also 200 + individual emails. And you are using an Excel Sheet that has the email addresses.

    If you are comfortable using a different macro, we may be able to get the solution you are seeking. The new code would be based on
    you listing the email addresses in a sheet within your Workbook project. Probably as you already have it ?

    Now, if you are needing to separate sub-groups from the total 200 + email addresses ... we'll need to add some more code to accomplish
    that.

    Let me know.

  3. #3
    Valued Forum Contributor
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,503

    Re: Issue resolving recipients

    Logit notes notwithstanding, couldn't you just remove the the "add recipient" code and replace it with
    Please Login or Register  to view this content.
    You will still need to add a for loop to go through all your customers, but this way outlook isn't being called to resolve the contact email address.
    The filter code is built into the answer at: https://www.excelforum.com/excel-pro...ook-email.html

    Let us know if you have questions.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,107

    Re: Issue resolving recipients

    .
    Yes ... after reviewing the code you provided in the other Forum post ... that is precisely the approach I had in mind.

+ 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. Macro to issue emails to multiple recipients with specific attachment
    By anshupillay in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2018, 04:09 PM
  2. [SOLVED] How to send Lotus email with VBA to more recipients and also to more copy recipients
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-20-2013, 03:23 PM
  3. VLOOKUP Issue - Not resolving data
    By dsniff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2011, 04:40 AM
  4. email multiple recipients issue
    By asreid2527 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2009, 11:33 PM
  5. resolving #VALUE!
    By cwnan64 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-28-2009, 01:11 PM
  6. Vlookup not Resolving
    By PatK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2006, 02:15 PM

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