This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 24%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hi, I have seen David JunFeng's solution to embedding inline images at https://social.msdn.microsoft.com/Forums/en-US/f8c701b7-fbef-4a1f-9549-2fd16191dd20/embed-images-with-cdo-mail-in-excel?forum=exceldev
The solution is for embedding inline images (graphics).
In addition, I would like to add an attachment to the email - as an attachment and not inline.
I am struggling to work out how to do this.
Can anyone (David JunFeng?) offer a solution please, i.e., the line of code I have to add - to solve this?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 90%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Just to clarify - you say you have now solved the issue ... but the phrasing of that paragraph suggests otherwise.
If not yet solved, review the code in the sub TestHTMLEMail in my example app.
This includes code for one inline image and for one or more attachments. You should easily be able to adapt the code to include additional inline images anywhere in the message
Hi Colin,
Apologies, I did express myself poorly.
Your example, and sample database, resolved requirement and my request completely.
Much appreciated.
You have offered a wonderful solution to anyone trying to send emails from Access, and in particular HTML emails!
Thanks,
Harris
Please see my example app https://www.isladogs.co.uk/email-tester/index.html
This includes both attachments and inline images (for HTML email) with CDO email from Access
However, many email clients now block inline images for security reasons so you cannot guarantee that the images you send will be displayed
Hi Colin,
Thanks for your reply. In fact my email system is based around your sterling example, which I discovered some years ago!
Your coding is the foundation of sending emails.
My question was however not fully answered - and I have solved my issue. What I was seeking an answer to, was to include inline images PLUS a separate attachment. In other words, two graphic images (banner and footer to the message), and in addition an attached pdf file.