Microsoft Office Tutorials and References
In Depth Information
E‑mailing a Single Worksheet
.Attachments.Add ActiveWorkbook.FullName
.Display ‘Change to Send
End With
‘Release object variables from system memory.
Set objOutlook = Nothing
Set objNameSpace = Nothing
Set objInbox = Nothing
Set objMailItem = Nothing
End Sub
11.
Press Alt+Q to return to the worksheet. Press Alt+F8 to show the macro dialog box, and test
the macro by selecting the macro name and clicking the Run button.
To view the video that accompanies this lesson, please select Lesson 28, available
at the following website: www.wrox.com/go/excelvba .
Search JabSto ::




Custom Search