Send To

Home Search Site Map

Up
Close
Exit
File Search...
Most Frequently Used
New...
Open...
Page Setup...
Permission
Print...
Print Area
Print Preview
Properties
Save
Save As...
Save as Web Page...
Save Workspace...
Send To
Web Page Preview

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Send To

This allows you to send the workbook by email, routing server, internet fax service, etc. (Certain options may not be available on certain networks/systems). You get several choices from the sub-menu for all the different options available. (Below)

Clicking on any of the email options should open your email client, such as Outlook or Outlook Express, etc. In latter versions of Excel (XP and up), selecting 'Send to> Mail recipient' has opened a mailing header within Excel allowing you to send the workbook or just the worksheet directly from Excel.

 'Send email for review' requires that the workbook be shared, via Tools>Share Workbook...

VBA Sub Mailwb()
Dim wb As Workbook
Set wb = ActiveWorkbook
wb.SendMail Recipients:="nick@nickhodge.co.uk", Subject:="Take a look at this"
End Sub

Top

Copyright Nick Hodge 2008. All Rights Reserved.