I currently have a email blast database that I can loop through and send out text.
I would like to add our company logo to the email and not as an attachment. I would like it to be right under the text.
here is a copy of the body of my email as it is right now.
strMessage = rsEmail.Fields("Company").Value & vbCrLf & vbCrLf & Forms![ExhibitorMailing]![txtmsg] & vbNullString & vbCrLf & vbCrLf & "Northeast, NSPI" & vbCrLf & "300J Campus Drive" & vbCrLf & "Morganville, NJ 07751" & vbCrLf & "Phone: 732-972-9111 Fax: 732-972-8690" & vbCrLf & "Website: www.nespapool.org Email: info@nespapool.org" & vbCrLf & vbCrLf & vbCrLf & "If you want to remove your email address from our list, reply to info@nespapool.org and put REMOVE EMAIL in the subject field and your email will be removed" & vbCrLf & vbCrLf & Forms![ExhibitorMailing]![txtmsg2]
If you notice the last bit of code I put in Forms![ExhibitorMailing]![txtmsg2] That is where I put the picture, and it is wrong because I get an error. How can I recode it so that I will send the logo in the body of the email?
I would like to add our company logo to the email and not as an attachment. I would like it to be right under the text.
here is a copy of the body of my email as it is right now.
strMessage = rsEmail.Fields("Company").Value & vbCrLf & vbCrLf & Forms![ExhibitorMailing]![txtmsg] & vbNullString & vbCrLf & vbCrLf & "Northeast, NSPI" & vbCrLf & "300J Campus Drive" & vbCrLf & "Morganville, NJ 07751" & vbCrLf & "Phone: 732-972-9111 Fax: 732-972-8690" & vbCrLf & "Website: www.nespapool.org Email: info@nespapool.org" & vbCrLf & vbCrLf & vbCrLf & "If you want to remove your email address from our list, reply to info@nespapool.org and put REMOVE EMAIL in the subject field and your email will be removed" & vbCrLf & vbCrLf & Forms![ExhibitorMailing]![txtmsg2]
If you notice the last bit of code I put in Forms![ExhibitorMailing]![txtmsg2] That is where I put the picture, and it is wrong because I get an error. How can I recode it so that I will send the logo in the body of the email?