+ Reply to Thread
Results 1 to 2 of 2

Email to Multple Recipients via Gmail CDO Method

  1. #1
    Registered User
    Join Date
    09-01-2015
    Location
    Connecticut, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Email to Multple Recipients via Gmail CDO Method

    Hi, I'm trying to enable an automated email send functionality using a macro. My challenge to this point is that I want the .To property to be dynamic instead of a discrete domain address. This way I can have the macro cycle through a list of recipients and send each their corresponding data, one by one. My initial strategy was that I would be able to equate it to a variable or just set it equal to Sheets("Sheet1").Cells(1,1).Value. But to this point neither option seems to work despite the fact that those options work for .TextBody, etc. Thoughts?

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

    Re: Email to Multple Recipients via Gmail CDO Method

    I normally recommend looking at Ron de Bruin's website. Everything youcould possibly want to know about integrating Excel, VBA and email.

    Or you could Google: excel vba email multiple recipients gmail -outlook

    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


+ 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. get a workbook in excel to email out through gmail not outlook
    By emussynski in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-21-2016, 12:19 AM
  2. Replies: 0
    Last Post: 04-17-2015, 06:01 AM
  3. [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
  4. [SOLVED] How to send Lotus email with VBA to more recipients and also to more copy recipients
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-20-2013, 03:23 PM
  5. 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
  6. compiling gmail email list
    By howwwie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2011, 09:34 AM
  7. email one sheet to many recipients based on email list
    By cdl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2008, 11:12 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