+ Reply to Thread
Results 1 to 6 of 6

VBA Code for Googles Gmail Email send

  1. #1
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    VBA Code for Googles Gmail Email send

    Hi All

    How do I amend the below code to allow for Googles Gmail Send.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,440

    Re: VBA Code for Googles Gmail Email send

    You don't. You go to Ron de Bruin's web site and get specific code for driving gmail.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: VBA Code for Googles Gmail Email send

    Hi TMS

    Thank you for feedback. I managed to adapt code as per below, but now error 438 - Object does not support this property or method.
    Code sticks at Add attachments.

    Please Login or Register  to view this content.
    Last edited by sintek; 07-15-2016 at 08:34 AM.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: VBA Code for Googles Gmail Email send

    Silly Me.....

    Please Login or Register  to view this content.
    should be
    Please Login or Register  to view this content.

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: VBA Code for Googles Gmail Email send

    Hi All

    The code runs successfully but when I view sent and received emails....Nothing can be found. Any ideas?

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: VBA Code for Googles Gmail Email send

    Hi All

    Below is working code.

    Please Login or Register  to view this content.
    Last edited by sintek; 07-15-2016 at 08:34 AM.

+ 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] Macro to send email via gmail program
    By excelnoob_15 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-13-2016, 06:52 PM
  2. Send an ALERT email to a GMAIL address if conditions are met in a specific cell
    By zeegerman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2015, 04:56 PM
  3. Send Email using Gmail to multiple "clients"
    By edneco in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-31-2015, 01:58 AM
  4. Replies: 0
    Last Post: 04-17-2015, 06:01 AM
  5. [SOLVED] Button to send an email via Gmail
    By Drayde in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-28-2014, 08:23 AM
  6. Send email through excel using gmail to multiple recipents
    By Neha3587 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2014, 09:04 AM
  7. Send Workbook as an Attachment Via Gmail - Code Review
    By psanghvi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2012, 04:37 AM

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