<div>
Hi<br />
I got the error<br />
Public member 'Attachment' on type 'IMsoEnvelopeVB' not found.
</div>


Hi
I got the error
Public member 'Attachment' on type 'IMsoEnvelopeVB' not found.

<div>
but of course you answered my question. Thanks very much
</div>


but of course you answered my question. Thanks very much

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I use the following code to build an email in the Mail Envelope<br />
I want to embed two small ranges in the body. How do I do this?<br />
<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; With Globals.ThisAddIn.Applicat<wbr />ion.Active<wbr />Sheet.Mail<wbr />Envelope<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Visible = True<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Item.To = oDetail<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Item.Cc = oDetail2<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Item.Subject = oDetail3<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Item.Body = oDetail4<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Attachment = oDetail5<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '.Item.Send()<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End With
</div>
</div>


Hi

I use the following code to build an email in the Mail Envelope
I want to embed two small ranges in the body. How do I do this?


            With Globals.ThisAddIn.Application.ActiveSheet.MailEnvelope
                        .Visible = True
                        .Item.To = oDetail
                        .Item.Cc = oDetail2
                        .Item.Subject = oDetail3
                        .Item.Body = oDetail4
                        .Attachment = oDetail5
                        '.Item.Send()
                    End With

Excel VBA Email Envelope Embed two ranges in the body

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.