Solved

How to write Body of an Email using VBA through Excel

Posted on 2011-02-21
1
788 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:srikanthv2322
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 13

Accepted Solution

by:
connectex earned 500 total points
ID: 34948560
This site has lots of examples: http://www.rondebruin.nl/sendmail.htm
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
Changing a few Outlook Options can help keep you organized!
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question