What is wrong with the VBA code?

[dcharland]

need help again.....

Why is this code going straight to the On error statment?

 If cell.Value Like "?*@?*.?*" And _
           LCase(Cells(cell.row, "G").Value) = "Yes" And Cells(cell.row, "I").Value = "" Then
             If Cells(4, "E").Value = "Yes" Then Set OutMail = OutApp.createItemFromtemplate(Cells(5, "C").Value) Else Set OutMail = OutApp.CreateItem(0)
On Error Resume Next

I'm 100% positive that G as "Yes" I is "" and E4 as "Yes". It must be something that i'm just not seing??

 

[Dryver14]

I'm not sure you can have if then else on the same line

But I could be wrong, I'm sure some one will tell me

 

[dcharland]

Re: What is wrong with the VBA code? SOLVED

Hi Dryver14,

the code was fine it was an issue with my .oft file

P.S. Your question is answered

Denis