Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Send Excel workbook as attachment
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="cmhoz" data-source="post: 402171" data-attributes="member: 31774"><p>I am desprately seeking a way to send an Excel workbook as an attachment to WHATEVER the default mail program is (in this case, OS X Mail).</p><p></p><p>I have a cross platform file - If the user is on a Windows system, there are lots of easy ways to send email. However, when the user is on a Mac OS X machine, the default mail options do not work (because they are linked to Outlook). SO... here's what I've tried...</p><p></p><p>1. </p><p>ActiveWorkbook.FollowHyperlink _</p><p>"mailto:me@isp.org" & _</p><p>"?subject=I have a dream.." & _</p><p>"&body=That one day soon this will work!"</p><p></p><p>Great. Calls up the default mail program. But - doesn't attach the current workbook.</p><p></p><p></p><p>2. Application.Dialogs(xlDialogSendMail).Show</p><p></p><p>3. All the different PC options... they all fail in OS X.</p><p></p><p>This is what excel generates what I record a macro to send workbook as attachment. But - when I play it back, it generates a runtime error and claims that xlDialogSendMail isn't valid.</p><p></p><p>HELP!!! There has to be SOMEONE out there who knows how to send an excel workbook on a Mac.... I just can't work it out, have even tried looking for an AppleScript solution, but that's a whole new world to me, so I'm very lost.</p></blockquote><p></p>
[QUOTE="cmhoz, post: 402171, member: 31774"] I am desprately seeking a way to send an Excel workbook as an attachment to WHATEVER the default mail program is (in this case, OS X Mail). I have a cross platform file - If the user is on a Windows system, there are lots of easy ways to send email. However, when the user is on a Mac OS X machine, the default mail options do not work (because they are linked to Outlook). SO... here's what I've tried... 1. ActiveWorkbook.FollowHyperlink _ "mailto:me@isp.org" & _ "?subject=I have a dream.." & _ "&body=That one day soon this will work!" Great. Calls up the default mail program. But - doesn't attach the current workbook. 2. Application.Dialogs(xlDialogSendMail).Show 3. All the different PC options... they all fail in OS X. This is what excel generates what I record a macro to send workbook as attachment. But - when I play it back, it generates a runtime error and claims that xlDialogSendMail isn't valid. HELP!!! There has to be SOMEONE out there who knows how to send an excel workbook on a Mac.... I just can't work it out, have even tried looking for an AppleScript solution, but that's a whole new world to me, so I'm very lost. [/QUOTE]
Verification
What is Apple's smallest desktop computer called?
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Send Excel workbook as attachment
Top
