Hi, I'm looking for help with a macro that no longer seems to work. I don't know what the cause of it might be. Pretty sure it's something fixable but I just don't know how to fix it.
I have attached a file and also a screenshot of where the error seems to be.
macro.PNG
Works fine for me.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
It's still not working for me.
Before I was getting the msgBox "Email was not sent"
Now I'm getting this. Maybe the problem is with Outlook but i'm able to send and receive emails on the account so i'm not sure why the macro isn't working.
Attachment 648792
Just tried it myself and it works for me too.
Just as a hint, when asking for help, you might want to set it as .display rather than .send
It will prevent your mailbox filling up and will prevent others from sending unnecessary emails.
Please Login or Register to view this content.
Noted. I'm still very inexperienced. Do you guys know what might be the problem though?
Ok I finally figured out that the reason the email wasn't being sent for me was because I didn't have an email address in the CC field.
Which now begs the question, how to adjust the code such that the email is still sent, even though one of the TO or CC fields might be blank.
Even though I didn't get the answer to my question in the post above I will close this thread.
Maybe its better to just go with one email address option rather than having two and then trying to figure out the code that allows for the different possibilities.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks