Macro to send email from Excel.

[vijanand1279]

Hi,

Could some one help with the code to extract the data from email content tab instead of the code I have given in .body itself.

In the attached I have made the email content (.Body) on the macro code itself. Is it possible to have the macro edited to have the email content taken from the tab "Email content"

Regards,
Vijay

[vijanand1279]

Could anyone please help me. I am looking for the email body to get extracted from "Email content" tab.

[VBA FTW]

Change your .body line to this

Please Login or Register  to view this content.

You'll need to expand this to include your full range.

[vijanand1279]

This works from email content tab. But how to change the value for each row to populate in email content tab. For eg the vendor name and invoice number should show up for each row.

[VBA FTW]

Please Login or Register  to view this content.

You need to work with this part of the code. Keep adding it to .Body, the "vbNewLine" will put whatever values you want next on a new line in your email

[vijanand1279]

I am not looking to have the next on new line. I want each row details to show in the body of the email. That means first row details in first email and second row details in the second row.

Regards,