PC Review

Thread Tools Rate Thread

Excel VBA - Send workbook as attachment - OS X

New Member
Join Date: May 2007
Posts: 1
      27th May 2007
I am desprately seeking a way to send an Excel workbook as an attachment to WHATEVER the default mail program is.

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...

ActiveWorkbook.FollowHyperlink _
"(E-Mail Removed)" & _
"?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

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....
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
can i send excel workbook as attachment form excel. Smart Akhtar Microsoft Excel Programming 1 26th Apr 2008 12:46 PM
Copy Excel Worksheet to new Workbook via VBA without Links to original Workbook JamesDMB Microsoft Access Form Coding 0 21st Mar 2007 07:13 PM
send excel workbook as attachment to multiple users =?Utf-8?B?Z3V6?= Microsoft Excel Programming 1 21st Feb 2007 03:58 PM
Excel VBA Close Workbook and Open Existing Workbook rjm65 Microsoft Excel Programming 1 22nd Dec 2004 07:56 AM
send as attachment-an active workbook through File menu of Excel using OE6 Ajey Microsoft Excel Discussion 1 11th Jun 2004 06:08 PM




All times are GMT +1. The time now is 10:00 PM.