Originally Posted by
DMT Dave
hi ridders, it seems to add the embedded logo but says it can't be displayed, I am not sure how to embed the image taken from the word doc located where my SigString is located, it certainly adds the square embedded and address and contact details but not the image!
How do you mean by referencing the image file ??, I am guessing to copy the bmp or jpg to a local folder and follow the path in vba then debug.print for example "mylogo" from the location ?, I think it's so close now but I haven't a great experience with integrating images with access! thank you for your help throughout
Apologies - didn't see this earlier
This is an example of HTML email code:
The image part has been highlighted in RED - replace with your own file path but same notation
i haven't included the SendHTMLEMailCDO function used to send the email as that's not relevant here
Code:
Sub TestHTMLEMail()
'setup email info
aTo = strSDAManagerEMail
'aCC = strSDAEMailSupport
aFrom = strSendUserName
aSubject = "Test HTML Email message - no attachments"
aHTMLBody = "This is a <FONT size=5><FONT color=#800000><B>TEST message</B><FONT size=3>.<FONT color=#000000>" & _
" to check <I>HTML email</I> with no attachments from the <B><I>" & GetProgramName() & "</B></I> program" & _
" <P><IMG border=0 hspace=0 alt='' src='file://G:/Programs/MendipDataSystems/CommonFiles/SDA/Images/SDAUpdater1.gif' align=baseline></P>"
'send the email using CDO email code
SendHTMLEMailCDO aTo, aCC, aSubject, aHTMLBody, aFrom, aPath
End Sub
and this is the email sent:
HTH