Solved

How to write Body of an Email using VBA through Excel

Posted on 2011-02-21
1
779 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
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

770 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