<div>
copy the select everything in the excel sheet and copy it to the clipboard (use Excel Automation). &nbsp;Then open the email message and paste the clipboard content to the message body. &nbsp;All this should be able to do using excel and outlook automation.
</div>


copy the select everything in the excel sheet and copy it to the clipboard (use Excel Automation).  Then open the email message and paste the clipboard content to the message body.  All this should be able to do using excel and outlook automation.

<div>
I do not accept the only answer offered, sorry, so if you want to close it, I would like a refund, please. &nbsp;Thanks, Dani.
</div>


I do not accept the only answer offered, sorry, so if you want to close it, I would like a refund, please.  Thanks, Dani.

<div>
DaniHuguet, an EE Moderator will handle this for you.<br />
Moderator, my recommended disposition is:<br />
<br />
&nbsp; &nbsp; Refund points and save as a 0-pt PAQ.<br />
<br />
DanRollins -- EE database cleanup volunteer
</div>


DaniHuguet, an EE Moderator will handle this for you.
Moderator, my recommended disposition is:

    Refund points and save as a 0-pt PAQ.

DanRollins -- EE database cleanup volunteer

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
What's the VB code for sending an Excel 2000 worksheet (not the whole book) as the body of an email (not attachment). &nbsp;In Office XP, you use the msoEnvelope, or .mailenvelope function, but in 2000??...<br />
<br />
Thanks,<br />
Daniela.
</div>
</div>


Hi,

What's the VB code for sending an Excel 2000 worksheet (not the whole book) as the body of an email (not attachment).  In Office XP, you use the msoEnvelope, or .mailenvelope function, but in 2000??...

Thanks,
Daniela.

Send Excel2000 worksheet as mailbody

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.