Sending mail through C# using Excel

[NaHn-PrAhFyT]

In Excel 2003 there is a sendmail option that allows you to send a
worksheet as the body of an email. I'm trying to do this with C# and i
can't seem to find out how, does anyone have experience doing this, or
any suggestions?

 

[Sijin Joseph]

Check out the discussion on MailSystem,MailSession etc. on this page
http://msdn.microsoft.com/library/d...e/html/wrgrfexcelapplicationobjectmethods.asp

 

[TommyBoy]

Check out the discussion on MailSystem,MailSession etc. on this page
http://msdn.microsoft.com/library/d...e/html/wrgrfexcelapplicationobjectmethods.asp

I've seen that article before, it doesn't actually show you to get the
sheet to become the body of the email as if you were to go into the
excel form and select file-send to-mail recipient-current page as body

 

[Sijin Joseph]

Using the MsoEnvelope object
Use the MailEnvelope property of the Document object, Chart object or
Worksheet object (depending on the application you are using) to return a
MsoEnvelope object.

The following example sends the active Microsoft Word document as an e-mail
to the e-mail address that you pass to the subroutine.

Sub SendMail(ByVal strRecipient As String)

'Use a With...End With block to reference the MsoEnvelope object.
With Application.ActiveDocument.MailEnvelope

'Add some introductory text before the body of the e-mail.
.Introduction = "Please read this and send me your comments."

'Return a Microsoft Outlook MailItem object that
'you can use to send the document.
With .Item

'All of the mail item settings are saved with the document.
'When you add a recipient to the Recipients collection
'or change other properties, these settings will persist.
.Recipients.Add strRecipient
.Subject = "Here is the document."

'The body of this message will be
'the content of the active document.
.Send
End With
End With
End Sub
//This is from Microsoft Excel help, The MsoEnvelope object should do the
trick