0 out of 1 rated this helpful - Rate this topic

How to: Send Workbooks by E-Mail Programmatically

Visual Studio 2010

You can send a workbook as an e-mail attachment. However, you cannot add text to the message you send.

Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

Note
You must be online and connected to your e-mail system to send e-mail. SendMail uses the Messaging Application Programming Interface (MAPI).

Call the SendMail method of the workbook and specify recipients and optionally a subject.
C#
VB
Copy
Globals.ThisWorkbook.SendMail("someone@example.com", "July Sales Figures", missing);

Call the SendMail method of the workbook and specify recipients and optionally a subject.

Copy


this.Application.ActiveWorkbook.SendMail("someone@example.com", "July Sales Figures", missing);

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ