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!!
Bookmarks