I have an emailing script that is getting this runtime error 13 type mismatch.
It creates an email and find the contact and the email address(es) based on the below.
Not sure why it is suddenly throwing me these errors in the contact column. I tried to select the cells and change the option to IGNORE errors, but that didn't work. Chose the General, Text, and that didn't work either.
Help please!
It creates an email and find the contact and the email address(es) based on the below.
Not sure why it is suddenly throwing me these errors in the contact column. I tried to select the cells and change the option to IGNORE errors, but that didn't work. Chose the General, Text, and that didn't work either.
Help please!
VBA Code:
TempFilePath = "C:\temp\"
contact = Worksheets("Sheet1").Cells(1, "e").Value (contains letters and numbers - getting error)
toemail = Worksheets("Sheet1").Cells(1, "d").Value (email addresses and some contains mixed letters and numbers-getting error)
ccemail = Worksheets("Sheet1").Cells(2, "d").Value
subject = Worksheets("Sheet1").Cells(2, "a").Value
body = Worksheets("Sheet1").Cells(3, "a").Value
File = Worksheets("Sheet1").Cells(1, "a").Value