strSubject = Trim(Mid(Replace(strSubject, vbCrLf, ""), 1, 100)) strRecipientName = Trim(Mid(strRecipientName, 1, 35)) strFromEmailName = Trim(Mid(strFromEmailName, 1, 35)) strRecipientEmailAddress = Trim(Mid(strRecipientEmailAddress, 1, 50)) strFromEmailAddress = Trim(Mid(strFromEmailAddress, 1, 50)) strRecipientName = Replace(strRecipientName, vbCrLf, "", 1, -1, 1) strFromEmailName = Replace(strFromEmailName, vbCrLf, "", 1, -1, 1) strRecipientEmailAddress = Replace(strRecipientEmailAddress, vbCrLf, "", 1, -1, 1) strFromEmailAddress = Replace(strFromEmailAddress, vbCrLf, "", 1, -1, 1) strRecipientName = Replace(strRecipientName, ",", "", 1, -1, 1) strFromEmailName = Replace(strFromEmailName, ",", "", 1, -1, 1) strRecipientEmailAddress = Replace(strRecipientEmailAddress, ",", "", 1, -1, 1) strFromEmailAddress = Replace(strFromEmailAddress, ",", "", 1, -1, 1) strRecipientName = Replace(strRecipientName, ";", "", 1, -1, 1) strFromEmailName = Replace(strFromEmailName, ";", "", 1, -1, 1) strRecipientEmailAddress = Replace(strRecipientEmailAddress, ";", "", 1, -1, 1) strFromEmailAddress = Replace(strFromEmailAddress, ";", "", 1, -1, 1) strRecipientName = Replace(strRecipientName, ":", "", 1, -1, 1) strFromEmailName = Replace(strFromEmailName, ":", "", 1, -1, 1) strRecipientEmailAddress = Replace(strRecipientEmailAddress, ":", "", 1, -1, 1) strFromEmailAddress = Replace(strFromEmailAddress, ":", "", 1, -1, 1) strRecipientName = Replace(strRecipientName, "<", "", 1, -1, 1) strFromEmailName = Replace(strFromEmailName, "<", "", 1, -1, 1) strRecipientEmailAddress = Replace(strRecipientEmailAddress, "<", "", 1, -1, 1) strFromEmailAddress = Replace(strFromEmailAddress, "<", "", 1, -1, 1) strRecipientName = Replace(strRecipientName, ">", "", 1, -1, 1) strFromEmailName = Replace(strFromEmailName, ">", "", 1, -1, 1) strRecipientEmailAddress = Replace(strRecipientEmailAddress, ">", "", 1, -1, 1) strFromEmailAddress = Replace(strFromEmailAddress, ">", "", 1, -1, 1) |