Hi Guys,
New here, but I'm stuck with one of my Macros. I got source code online to automate sending filtered cells in Excel to outlook with the press of a button, which is awesome, but I need a little help.
My Macro is working, and sends the filtered files to the proper addresses in the "Mailinfo" tab. My problem, however, comes with not knowing if an email HASN'T been sent.
Here is what Happens:
When there is no corresponding email address for an entry in the "MailInfo" tab, obviously it doesn't send an email to that person. What I want, however, is an error message to pop up saying, "The following poeple did not recieve an email beause they were not in the correct tab", while STILL sending automated emails to the rest of the list.
Now the code is something like "On Error Resume Next", I still want it to resume, but I want a message box first so I can not who was on the tab, but will not be getting an email.
For reference, I attatched an easy sample file with my macro.
Any and all help is greatly appreciated!
J
Bookmarks