+ Reply to Thread
Results 1 to 4 of 4

Macro to Email set of cells with identified email list and subject line with outlook

  1. #1
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Macro to Email set of cells with identified email list and subject line with outlook

    I am looking for some help with a macro to email the group of cells B2:K20 pasted in the body of the email via outlook.
    I will have the email list identified N2:N15
    The subject line will be cell O2

    Email will be sent via outlook

    Any help with making this macro would be greatly appreciated.

    I have attached a blank file with the section identified that will be used for the email.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Re: Macro to Email set of cells with identified email list and subject line with outlook

    I have been working on it and the sent to list is not working
    Here is the code so far and any help to make it better is greatly appreciated

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,860

    Re: Macro to Email set of cells with identified email list and subject line with outlook

    Hi Aaron,

    Try the following code which is included in the attached modified copy of your sample workbook.
    Please Login or Register  to view this content.
    To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

    Lewis
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Re: Macro to Email set of cells with identified email list and subject line with outlook

    Thank you for your help

+ 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. Email Macro with Unique Subject Line
    By InkyDrinky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2017, 11:24 AM
  2. Replies: 6
    Last Post: 11-24-2015, 01:32 PM
  3. Replies: 0
    Last Post: 06-18-2015, 05:35 PM
  4. Macro Automate Email Subject Line Based on Cell Value
    By richzipday in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2013, 06:33 PM
  5. [SOLVED] Create macro to send worksheet as body of email using cells as subject line
    By LindaABH in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-16-2012, 07:43 PM
  6. Replies: 6
    Last Post: 12-02-2011, 02:14 PM
  7. Replies: 0
    Last Post: 08-16-2011, 02:40 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