<div>
Are you planning to send the SMS? Are you planning to use MOSA?<br />
<br />
Sid
</div>


Are you planning to send the SMS? Are you planning to use MOSA?

Sid

<div>
1st: Options is undefined<br />
2nd: From what i've read, SendMailAttach seams to be linked to Word Interop... (<a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.word.options.sendmailattach(office.11).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/microsoft.office.interop.word.options.sendmailattach(office.11).aspx</a>)<br />
<br />
Try to dump that line and see if it does what you want.
</div>


1st: Options is undefined
2nd: From what i've read, SendMailAttach seams to be linked to Word Interop... (http://msdn.microsoft.com/en-us/library/microsoft.office.interop.word.options.sendmailattach(office.11).aspx [http://msdn.microsoft.com/en-us/library/microsoft.office.interop.word.options.sendmailattach(office.11).aspx])

Try to dump that line and see if it does what you want.

<div>
<div class="content wysiwyg-content">
Using Outlook email how to send a text message (not a workbook)<br />
I tried the code below but I get &quot;Object Required&quot; error <br />
Regards<br />
Brian 
<pre><code id="code-7972573">Sub DoneMessage()
    Options.SendMailAttach = False
    ActiveWorkbook.SendMail _
    Recipients:=[TenDigitPhoneNumber] _
        &amp; &quot;@&quot; &amp;   [TextMessageDomain],  _
    Subject:=[SubjectLine]
End Sub</code></pre>
</div>
</div>


Using Outlook email how to send a text message (not a workbook)
I tried the code below but I get "Object Required" error 
Regards
Brian 

Excel VBA Send Text Message

Within Internet message handling services (MHS), a message transfer agent or mail transfer agent (MTA) or mail relay is software that transfers electronic mail messages from one computer to another using a client–server application architecture. A MTA implements both the client (sending) and server (receiving) portions of the Simple Mail Transfer Protocol (SMTP). The terms mail server, mail exchanger, and MX host may also refer to a computer performing the MTA function. The Domain Name System (DNS) associates a mail server to a domain with mail exchanger (MX) resource records containing the domain name of a host providing MTA services.

Email Servers

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