vba email send from excel - ignore second email address if "ENTER EMAIL ADDRESS"

[nigelog]

I am using the below code to email a worksheet from a macro using email addresses in cells chosen from a dropdrown list. The last cell reference is to allow the user to enter email address not available on the dropdown lists, an "ad hoc" address that the code then changes the cell entry back to "ENTER EMAIL ADDRESS".

I would like the macro to test the value of cell [f14] and if "ENTER EMAIL ADDRESS" ignore and do not add to the recipient list along with cell [I6]

Please Login or Register  to view this content.

any assistance appreciated. Rgds....

[nigelog]

Please Login or Register  to view this content.

longwinded way of doing it but does the job....

[cytop]

Assign the first email address to the field including the semi-colon separator; then, if the second cell contains a valid email address, append that to the 'To' field. Alternatively use an inline IIF() function to check the value of the second.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

IF (or the Inline version, IIF()) is the most basic of VBA control structures - Something you need to know, and there's absolutely no need for the 'long winded' version.

[nigelog]

Thank You Cytop, much neater....will look up IIF function now