+ Reply to Thread
Results 1 to 4 of 4

Send Mail VBA working on PC but not on Mac

  1. #1
    Registered User
    Join Date
    03-29-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    12

    Send Mail VBA working on PC but not on Mac

    I borrowed some VBA to send a worksheet as PDF. It works perfectly on my PC, but does nothing on a MAC. I get no error codes on the MAC. But the email does not send. Outlook is installed on my MAC, is working, and is set as the default email program.

    The code I am using is:


    Please Login or Register  to view this content.
    Thank you for any suggestions

  2. #2
    Registered User
    Join Date
    03-29-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    12

    Re: Send Mail VBA working on PC but not on Mac

    An update. I am not sure what changed. But now when I run this macro, something happens. A box appears with the label "save" and hen immediately another box arrives on top of it that says "Print. Error while printing.

    Thanks for any suggestions

  3. #3
    Registered User
    Join Date
    03-29-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    12

    Re: Send Mail VBA working on PC but not on Mac

    Another update. When I use excel 2011 for Mac rather than excel 2016, the program successfully creates a PDF. But it does not attach it to an email or send that email.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Send Mail VBA working on PC but not on Mac

    Mac isn't my area but EMAILS in the VBA space it does require specific coding which is different to the Windows counterpart

    here is the go to resource on VBA Email talking about MAC email
    https://www.rondebruin.nl/mac/mail.htm

    more specifically
    Make and Mail PDF files with VBA code on your Mac
    https://www.rondebruin.nl/mac/mac005.htm
    Last edited by humdingaling; 09-24-2017 at 10:37 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Send Mail VBA working on PC but not on Mac
    By scott altman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2017, 01:24 PM
  2. Vba code to send mail not working
    By aakhan2011 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2014, 03:13 PM
  3. Replies: 1
    Last Post: 03-11-2014, 12:24 PM
  4. [SOLVED] Sub Routine to Send E-Mail from Excel with attachement not working. Help!
    By TheLittlePrince in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2013, 01:26 PM
  5. How to e-mail selected row and use e-mail address in a cell to send e-mail from excel
    By syedalamgir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2010, 02:15 AM
  6. URGENT! Please please help me get smtp mail send working..
    By Duncan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2006, 09:55 AM
  7. [SOLVED] "Send to Mail Recipient" icon not working
    By Lynde in forum Excel General
    Replies: 7
    Last Post: 06-23-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1