+ Reply to Thread
Results 1 to 4 of 4

Sending to gmail through VBA

  1. #1
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Sending to gmail through VBA

    Hi,

    I need to send through VBA emails to GMAIL accounts.

    I've been reading\trying many threads but none have solved my porblem.

    The code below is the shortest I've encountered. It returns:

    "The "SendUsing" configuration value is invalid"

    Help is needed

    Please Login or Register  to view this content.
    Last edited by GIS2013; 07-21-2014 at 08:42 AM. Reason: Typo
    Please * if you like the answer

  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,091

    Re: Sending to gmail through VBA

    This works for me:

    Please Login or Register  to view this content.

    Best bet is to go to Ron de Bruin's web site for all sorts of examples.


    Regards, TMS
    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 Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: Sending to gmail through VBA

    Splendid TMS, It's working! and I'll play with this
    Last edited by GIS2013; 07-21-2014 at 09:08 AM. Reason: Typo

  4. #4
    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,091

    Re: Sending to gmail through VBA

    You're welcome. Thanks for the rep.


    http://en.m.wikipedia.org/wiki/Colla...n_Data_Objects


    Regards, TMS

+ 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. Sending Gmail works perfectly but i want different attachments to differnt people
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2014, 01:14 PM
  2. Sending mail with range as body using GMAIL
    By vssoma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2014, 05:40 AM
  3. [SOLVED] Gmail not loading in Windows 7
    By arlu1201 in forum Microsoft Windows Help
    Replies: 5
    Last Post: 12-20-2012, 04:43 AM
  4. Sending email using Gmail and attaching workbook.
    By vitt4300 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2012, 02:28 AM
  5. from excel to gmail tranfer
    By ohnono in forum Excel General
    Replies: 2
    Last Post: 08-05-2008, 07:07 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