This demonstration covers using Excel as a data source to compose a message in Word that is sent out in an email in Outlook (this demonstration uses Office 2013, but the principles are the same for other versions).
You can watch the recording (2:51 in length)
or download the video file
