Excel VBA - Send workbook as attachment - OS X

Discussion in 'Webmaster / Programming' started by cmhoz, May 27, 2007.

  1. cmhoz

    cmhoz

    Joined:
    May 27, 2007
    Messages:
    1
    Likes Received:
    0
    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...

    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

    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....
     
    cmhoz, May 27, 2007
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. cmeyer

    VBA Excel - Open an already open workbook.

    cmeyer, Dec 15, 2005, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    1,018
    cmeyer
    Dec 15, 2005
  2. rprewitt

    How to send current Word document as Outlook attachment?

    rprewitt, Jan 16, 2009, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    2,260
    izzop
    Jun 25, 2009
  3. coolminded2005

    VBA Code to save file and send as email

    coolminded2005, Apr 8, 2009, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    1,618
    knight00779
    Apr 14, 2009
  4. smithb2

    Excel VBA to Newer Excel Version

    smithb2, Aug 19, 2013, in forum: Webmaster / Programming
    Replies:
    2
    Views:
    1,855
    smithb2
    Apr 28, 2014
  5. ashikqubee
    Replies:
    4
    Views:
    1,798
    ashikqubee
    Jan 5, 2014
Loading...

Share This Page