+ Reply to Thread
Results 1 to 4 of 4

How to change Ron de Bruin's code to include a list of email addresses

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    Ottawa Canada
    MS-Off Ver
    Excel 2003
    Posts
    20

    How to change Ron de Bruin's code to include a list of email addresses

    Good Morning,

    I have an excel spreadsheet that I go into and send one tab of information to each recipient. There are 40+ tabs, and I would like to adjust Ron's code to include a tab with email addresses.

    Ideally when I run the macro on each tab, I want the code to look at a separate tab called addresses, find the name on the particular tab that is to be mailed (in column A for example the tab name is XPW75) and check for the address that is associated with it (in column B), and proceed to send the e-mail.

    Is this even possible??

    This is the code currently...and it works perfectly with Groupwise. It creates the excel attachment, opens the new e-mail with the attachment inside. I just have to input the correct address "[email protected]".

    Any geniuses out there, who can help a girl out??


    Please Login or Register  to view this content.
    Last edited by jeepjenn; 06-25-2014 at 09:35 AM. Reason: oops! sorry, forgot the code tags!!

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: How to change Ron de Bruin's code to include a list of email addresses

    There, there. Fear not, fair maiden!

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    07-20-2012
    Location
    Ottawa Canada
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to change Ron de Bruin's code to include a list of email addresses

    Thank You!!
    Going to try it now!!

  4. #4
    Registered User
    Join Date
    07-20-2012
    Location
    Ottawa Canada
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to change Ron de Bruin's code to include a list of email addresses

    hmmm...

    That didn't work. I appreciate the effort though!

    I found something on line, and tried this, and it worked!! http://www.exceltip.com/mail-send-an...oft-excel.html

    It doesn't do EXACTLY what I want, but its close enough. I just have to have the destination email address in cell A1 on each tab, and it works!!!

+ 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] Change code to include picture in body of email
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2013, 01:22 PM
  2. Replies: 1
    Last Post: 08-09-2011, 10:58 PM
  3. Change this code to create one email with all the addresses found
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-15-2008, 08:52 PM
  4. Look up a list of email addresses?
    By akopp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2008, 05:54 PM
  5. [SOLVED] Change email addresses
    By Frank C in forum Excel General
    Replies: 4
    Last Post: 11-09-2005, 01:20 PM

Tags for this Thread

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