Problem copying cells into email

[waratdenison]

Having a little problem copying cells into the body of my email. Found a nice looking code by Ken Puls and modified it for my situation. The problem I have now is it says that I get an Argument is not Optional error with the email.

Goal - to generate an email every time my target value is greater than 200 and add certain cells of information to that email and to have it email out to the email address in column X. I feel this should work just cannot figure out where code is not optional. Any help would be great.


I'm using excel 2010 and outlook.

First code is change event second is email.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[judgeh59]

the "If IsNumeric(target.Value) And target.Value > 200 Then Call Send_Selected_Mail_Only"

Send_Selected_Mail_Only requires a argument....see the beginning of the SUB C1 as range....

[waratdenison]

Sorry but I am a true novice, have no real knowledge when it comes to doing more complex codes like this. Is the issue that the (target.Value) and (cl As Range) are not compatible? If so do I need to start over? Again sorry I'm not more knowledgeable on this subject and thanks for the help.

[judgeh59]

not a problem.....and yes and no

yes, the problem is that target.value is the value of a cell and the SUB parameter is looking for a RANGE
without having data I can only "guess" at the code but this might work

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

no, you don't have to start over...

hope this helps

[waratdenison]

Thanks again that seemed to fix that issue though now the with cl.parent line is giving an object error. I'm not sure what this command even does. Sorry to continue to ask for help.

[judgeh59]

is it possible to upload a sample of the file....of course, remove any confidential data.....it's a lot easier than me just guessing....if possible....thanks

[waratdenison]

Here is a copy of the log I'm using. Hopefully there is enough information there. Thanks.