Solved

Email automation through Excel

Posted on 2014-03-17
2
286 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 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
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
Comment Utility
Perfect, thanks :)
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Create high volume marketing opportunities using email signatures with these top 10 DOs and DON'Ts of email signature marketing.
Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

744 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

16 Experts available now in Live!

Get 1:1 Help Now