Send Outlook email with table based on sum of cells in excel VBA

[tonyjyoo]

Hello,

I need assistance sending an outlook email from an excel file with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>.

Every email message will have the following content:


"Hi:

We are expecting the following NSCC Deposits.

	NSCC Deposits
Account Name:	Company A	Company B	Company C	Company D
Account Number:	412-170-6972	412-170-6956	412-170-6915	412-170-6931
Credit Amount:	$$	$$	$$	$$

<tbody>
</tbody>

Thanks,

Tony"

*** where each of the "Credit Amounts" in my table would be a SUM of 2 cells in a workbook I have - specifically, Company A's credit amount would be the sum of cells J26 and J27; Company B would be the sum of cells L26 andL27; etc. Is there a way I can create a macro within my excel workbook, have it look at the sum of these cells and send an email? The credit amounts in the body of my email are the only things changing; everything else is static.

Please let me know if you have any questions.

Thanks,
Tony

 

[tonyjyoo]

Again, I would really want it to be in the format I set up in post #1.

 

[Trevor_S]

When I've tried the HTML provided just as a webpage, there are borders between rows and columns, so I don't know if the problem is just how Outlook displays it. As I've explained before, I no longer have access to Outlook, so can't test it. Therefore I'm not sure that there's much more I can do.

But, there's no harm in trying to tweak the HTML to see what you can do. As I've suggested before, try putting something together in notepad and opening in a browser. There's plenty of information on HTML commands available on the internet. Trial and error is probably the best option now.