Reply to thread

Message

<blockquote data-quote="cmhoz" data-source="post: 403477" data-attributes="member: 31774">Almost got it!&nbsp; Made some changes... now it looks like this:[CODE]&nbsp; &nbsp; Public Sub MailSendMail(theBook As Workbook, _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; recipient As String, subject As String)&nbsp; &nbsp; &nbsp; &nbsp; Dim mailStr As String&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mailStr = _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;Tell application &quot;&quot;Mail&quot;&quot;&quot; &amp; vbNewLine &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;make new outgoing message with properties&quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;{recipient:&quot;&quot;&quot; &amp; recipient &amp; &quot;&quot;&quot;,subject:&quot;&quot;&quot; &amp; subject &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&quot;&quot;,attachment:&quot;&quot;&quot; &amp; theBook.FullName &amp; &quot;&quot;&quot;,visible:true}&quot; &amp; vbNewLine _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp; &quot;end tell&quot;&nbsp; &nbsp; &nbsp; &nbsp; MacScript mailStr&nbsp; &nbsp; End SubSub sendmessage()&nbsp; &nbsp; MailSendMail ThisWorkbook, &quot;name@address&quot;, &quot;This is the subject&quot;End Sub[/CODE]BUT... the recipient isn't showing up in the message.&nbsp; Subject is fine, but no recipient....</blockquote>

[QUOTE="cmhoz, post: 403477, member: 31774"] Almost got it! Made some changes... now it looks like this: [CODE] Public Sub MailSendMail(theBook As Workbook, _ recipient As String, subject As String) Dim mailStr As String mailStr = _ "Tell application ""Mail""" & vbNewLine & _ "make new outgoing message with properties" & _ "{recipient:""" & recipient & """,subject:""" & subject & _ """,attachment:""" & theBook.FullName & """,visible:true}" & vbNewLine _ & "end tell" MacScript mailStr End Sub Sub sendmessage() MailSendMail ThisWorkbook, "name@address", "This is the subject" End Sub[/CODE] BUT... the recipient isn't showing up in the message. Subject is fine, but no recipient.... [/QUOTE]

Verification

What is Apple's smallest desktop computer called?