+ Reply to Thread
Results 1 to 5 of 5

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.

    The code I am using is:

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

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

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

    Is Outlook available on the Mac? A CDO method might be better.

  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

    I do have outlook installed on the MAC and have it set to be the default email program. The outlook program is working.

    I would be happy to try a CDO. But my skills are quite limited. Sending a PDF was an important feature to me. And I did not find a CDO for this feature when I searched. If you have suggestions, I would be grateful.

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

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

    I know that some of the coding is different between a PC and a MAC, however, I do not know enough to know what would need to be changed. You might want to mark this post as solved and open another one in the "...for other platforms" (MAC, Google....) section of this forum. Here is the link
    https://www.excelforum.com/for-other...mobile-os-etc/
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

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

    Thanks. I will do that.

+ 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. 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
  2. Replies: 1
    Last Post: 03-11-2014, 12:24 PM
  3. [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
  4. Automatic send email (without even click send in mail software) with excel vba ??
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2013, 08:31 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