<div>
<div class="content wysiwyg-content">
I want to fill the Body of an New Email with the intended text using VBA through Excel<br />
<br />
EX:<br />
<br />
I want to Address as below in the EMail body,<br />
<br />
Hi,<br />
<br />
Below is the result of your Excel Query,<br />
<br />
<br />
<br />
Regards,<br />
Srikanthv2322<br />
<br />
<br />
I want to fill this EMail at a click of Command Button in . Excel<br />
<br />
PLease let me know the code for the above, also please let me know how to insert line breaks in the body of an EMail
</div>
</div>


I want to fill the Body of an New Email with the intended text using VBA through Excel

EX:

I want to Address as below in the EMail body,

Hi,

Below is the result of your Excel Query,



Regards,
Srikanthv2322


I want to fill this EMail at a click of Command Button in . Excel

PLease let me know the code for the above, also please let me know how to insert line breaks in the body of an EMail

How to write Body of an Email using VBA through Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.