Set rs1 = db.OpenRecordset("SR")
Loop through rs1 to grab vendor emails
salesrep = rs1![RepEMail] 'isolates the rep email field
DoCmd.SendObject acSendTable, "ExpSRout", acFormatXLS, salesrep, , , "Specif.....
I can send it to an email in my own contact list through outlook. However when I...