电话号码必须有才行:
....
For Each r As Row In Tables("咨询登记").Rows If r.IsNull("电话一") = False AndAlso r.IsNull("学员姓名") = False Then FoxSMS.SendMsg(r("电话一"), r("学员姓名") &":" & str) End IfNext