Macro for Email attachments from excel list fails when first line is " "

I have this macro that is supposed to send an email with an attachment based on a list in excel. The excel file is populating based on if/then to match certain criteria. So the problem is if the first line results in a " " no emails are sent. Anybody have any solutions? The macro is below with an outline of the data it pulls from

Doc2.docx


Sub Send_email_fromexcel()
Dim edress As String
Dim subj As String
Dim message As String
Dim outlookapp As Object
Dim Outlookmailitem As Object
Dim myAttachments As Object
Dim path As String
Dim lastrow As Integer
Dim attachment As String
Dim x As Integer
x = 1


Do While Sheet4.Cells(x, 1) <> ""
'fOR X=1 To 10
Set outlookapp = CreateObject("Outlook.application")
Set Outlookmailitem = outlookapp.createitem(0)
Set myAttachments = Outlookmailitem.Attachments
path = "G:\"
edress = Sheet4.Cells(x, 5)
subj = "bills"
Filename = Sheet4.Cells(x, 8)
attachment = path + Filename
Outlookmailitem.To = edress
Outlookmailitem.cc = ""
Outlookmailitem.bcc = ""
Outlookmailitem.subject = subj
Outlookmailitem.body = "Kim, Bills for locations you are attached. Thanks!"

myAttachments.Add (path + Filename)
Outlookmailitem.display
Outlookmailitem.send

lastrow = lastrow + 1
edress = ""
x = x + 1
On Error Resume Next

Loop
Set outlookapp = Nothing
Set Outlookmailitem = Nothing
End Sub

I assume you mean the cell is "" instead of " " as I would think a " " would work.

Change x=1 to:

Please Login or Register  to view this content.