Solved

Email automation through Excel

Posted on 2014-03-17
2
287 Views
Last Modified: 2014-03-17
I need to create a VBA routine that reads information (an email address and some body text) from various cells in Excel, and sends the information as an email through Outlook.

Does anyone have a simple code example that I can modify..?
0
Comment
Question by:PerMagnusStrom
2 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39933781
Hi,

The site of Ron deBruin has very good examples on how to do it

http://www.rondebruin.nl/win/s1/outlook/bmail5.htm

Regards
0
 

Author Closing Comment

by:PerMagnusStrom
ID: 39933989
Perfect, thanks :)
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

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.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now