I have a macro to send email from excel.
I have created a column "A" having email address, which infact is a lookup value from anotherworkbook.
My problem is when value in column A is manuelly entered, the macro runs & email is sent.
But when I use lookup formula in column A, macro gets run but no email is sent.
Any suggestion & Help. following is part of my macro.
![]()
[Dim OutApp As Object Dim OutMail As Object Dim cell As Range Application.ScreenUpdating = False Set OutApp = CreateObject("Outlook.Application") On Error GoTo cleanup For Each cell In Columns("A").Cells.SpecialCells(xlCellTypeConstants) If cell.Value Like "?*@?*.?*" And _ LCase(Cells(cell.Row, "U").Value) = "y" Then Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = cell.Value & ";" & cell.Offset(0, 2).Value 'or .To = "91" & cell.Value & ";91" & cell.Offset(0, 2).Value .Subject = "Booking SMS" .Body = Cells(cell.Row, "AD").Value & vbNewLine & Cells(cell.Row, "AE").Value .Send 'Or use Display. End With On Error GoTo 0 Set OutMail = Nothing End If Next cell]
Bookmarks