CDO Email, specific cells in the body

[Oximoxi]

Hey all!

Is it possible to send an email through SMTP server using CDO (no Outlook!) and insert specific cells in to the body of the email? I have a functioning macro for sending emails, but I strugle with the body content. I would like to insert specific region in to the body of the email. Cells from columns A-N and from the last filled row. Is it possible? I can't figure out how to do it.

[p45cal]

Already being dealt with in a cross post.
Oximoxi, read: http://www.excelguru.ca/content.php?184

[Oximoxi]

OK. I just didn't get helpful answer, so I thought I could try it here.

[Logit]

.
You should always post the links to other sites that have the same question. That helps folks to determine if you have already received an answer and not duplicate someone else's answer.
Remember that we are all volunteers / without pay. Most of the folks on the forums have full times jobs in programming and do volunteer work when things are "slow". Respect their time and
efforts.

Here is a link to an excellent resource (considered the bible for emailing via Excel) : https://www.rondebruin.nl/win/s1/cdo.htm

[Oximoxi]

I understand. But on many forums it is forbidden to post links to any other forums. I have asked the same question about CDO mail body here:
https://www.mrexcel.com/forum/excel-...ells-body.html

I know Ron's web. At first, he helped me a lot. But I still can't find the solution to my specific problem.

[Logit]

.
I wish I could be of assistance to you. Admittedly, I have not been able to get Ron's CDO example to work either. I am certain it does 'cuz he has a great reputation in that area ... I'm obviously missing something
that is preventing the CDO code to function as designed.

Hopefully someone else here on the Forum will assist.

[Oximoxi]

SOLVED!
Solution here:

https://www.mrexcel.com/forum/excel-...ml#post5083876