Need help sending outlook email based on sum of some cells in excel file

[tonyjyoo]

Hello,

I need assistance sending an outlook email from an excel file with VBA.

Every email message will have the following content:


"Hi:

We are expecting the following NSCC Deposits.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]NSCC Deposits[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Account Name:[/TD]
[TD]Company A[/TD]
[TD]Company B[/TD]
[TD]Company C[/TD]
[TD]Company D[/TD]
[/TR]
[TR]
[TD]Account Number:[/TD]
[TD]412-170-6972[/TD]
[TD]412-170-6956[/TD]
[TD]412-170-6915[/TD]
[TD]412-170-6931[/TD]
[/TR]
[TR]
[TD]Credit Amount:[/TD]
[TD]$$[/TD]
[TD]$$[/TD]
[TD]$$[/TD]
[TD]$$[/TD]
[/TR]
</tbody>[/TABLE]

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 and L27; 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]

Hello,

I need assistance sending an outlook email from an excel file with VBA.

Every email message will have the following content:


"Hi:

We are expecting the following NSCC Deposits.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]NSCC Deposits[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Account Name:[/TD]
[TD]Company A[/TD]
[TD]Company B[/TD]
[TD]Company C[/TD]
[TD]Company D[/TD]
[/TR]
[TR]
[TD]Account Number:[/TD]
[TD]412-170-6972[/TD]
[TD]412-170-6956[/TD]
[TD]412-170-6915[/TD]
[TD]412-170-6931[/TD]
[/TR]
[TR]
[TD]Credit Amount:[/TD]
[TD]$$[/TD]
[TD]$$[/TD]
[TD]$$[/TD]
[TD]$$[/TD]
[/TR]
</tbody>[/TABLE]

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 and L27; 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

Bump please.

 

[tonyjyoo]

Anyone???