PDA

View Full Version : [SOLVED] CDO Email, specific cells in the body



Oximoxi
05-31-2018, 01:58 AM
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
05-31-2018, 02:05 AM
Already being dealt with in a cross post.
Oximoxi, read: http://www.excelguru.ca/content.php?184

Oximoxi
05-31-2018, 02:50 AM
OK. I just didn't get helpful answer, so I thought I could try it here.

Logit
06-05-2018, 03:41 PM
.
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
06-07-2018, 07:18 AM
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-questions/1057028-cdo-email-specific-cells-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
06-07-2018, 07:33 AM
.
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
06-08-2018, 01:58 AM
SOLVED!
Solution here: :yes

https://www.mrexcel.com/forum/excel-questions/1057028-cdo-email-specific-cells-body.html#post5083876