Results 1 to 9 of 9

VBA to send email

Threaded View

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Hartland, WI
    MS-Off Ver
    Excel 2013 Professional Plus
    Posts
    73

    VBA to send email

    I need a vba that sends a multiple different range to a different recipient for each range.

    For example, I have a range in A1-F30, with an email address and subject in H14:H15.
    Then a different range in A32:F62, with a different email address and subject in H45:H46
    And so on with possibly 100 different ranges and email addresses.

    Is there a vba that will send a different email to all of those email addresses, with the range in the body of the email?
    Last edited by gillyr7; 01-03-2014 at 11:47 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-09-2013, 03:46 PM
  2. Send New Email W/ Body of Received Email, Then Delete Sent Email
    By edneal2 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 07-01-2013, 12:45 AM
  3. send selected range in email with default outlook email signature included
    By mdsickler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 10:50 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. Code to send Email wont send everytime
    By tanktata in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-11-2011, 04:44 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