Choose your language

Simple Email

Basic Exercise


Statement

Send a simple email (unformatted text) that is readable by all MS Outlook versions. Include in the body of the text the net profit of the income statement.

Note: MS Outlook needs to be configured for this macro to function correctly.


Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Use Outlook object library to create the code then remove the library and alter the code to the variable values as they were assigned by Outlook (late binding)

Place the emails .Display right after the .BodyFormat or the email signature might be omitted. Also, do not forget to place & .body at the end of the emails text or the signature might by omitted as well.


Show Answer

Download exercise Download answer



SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2019 SuperExcelVBA | ABOUT

Protected by Copyscape