Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Nov 2015
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel: Send Range of Cells to Email Based on Contents of Cells?

    I have a report that contains info about training compliance for 1000s of people in scores of departments. Is there a quick way to have MS XL email (via Outlook) to each department manager only the rows that contain the employess in their departments?

    Here's an example:



    By the by, I'm VB and macro illiterate so simple is much appreciated.

    Thanks much,

    --Allen

    .

  2. #2
    New Lounger
    Join Date
    Nov 2015
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Don't know why the table didn't show up but I attached it here.

    Thanks again,

    --Allen

    .
    Attached Files Attached Files

  3. #3
    jwoods
    Guest

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Duplicate removed and content merged.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    New Lounger
    Join Date
    Nov 2015
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by RetiredGeek View Post
    Duplicate removed and content merged.
    Thanks. Musta double-tapped the Send.

    --Allen

    .

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Lodestone,

    Very doable. Can you provide what you would like in the subject and body of the email. Could you also amend your spreadsheet to include the manager's emails in a column? Will this be sent only one time, repeatedly, or repeatedly but only to those who have new employees that were not yet included in an email?

    Maud

  7. #7
    New Lounger
    Join Date
    Nov 2015
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Maudibe View Post
    Lodestone,

    Very doable. Can you provide what you would like in the subject and body of the email. Could you also amend your spreadsheet to include the manager's emails in a column? Will this be sent only one time, repeatedly, or repeatedly but only to those who have new employees that were not yet included in an email?

    Maud
    Maud,

    Thank you! Thank you! I've attached the file w/ an email column. Since we have to build the report manually each time--due to the limitations of the software from which we get the data--running once is enough but having access to any code to be inserted each time would be a real boon.

    Subject:
    List of Non-compliant Employees

    Body:
    Greetings,

    Below is a list of the employees who are out of compliance for the listed required education. Please be sure they are enrolled in the next available session.

    Thank you,

    --Organizational Development




    Thanks again,

    --Allen

    .
    Attached Files Attached Files

  8. #8
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    lodestone,

    Thanks for the sample. Having a blank pre-formatted macro loaded template spreadsheet that you enter the data into would be the best approach. Can you describe how the data is extracted from your source app? There may be a way to automate an import

    Maud

  9. #9
    New Lounger
    Join Date
    Nov 2015
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Maudibe View Post
    lodestone,

    Thanks for the sample. Having a blank pre-formatted macro loaded template spreadsheet that you enter the data into would be the best approach. Can you describe how the data is extracted from your source app? There may be a way to automate an import

    Maud
    The data comes from a hosted learning management system's reports which are exported to XL spreadsheet--the formatting on them is so bad I have to copy and paste and reformat the data on a fresh page. Also, the canned reports don't cover the waterfront so I also have to do some data manipulation from multiple reports using VLOOKUP, etc. before sending out. Hence the reason I'm looking for ways to reduce the cumbersome factor where I can.

    Thanks again,

    --Allen

    .

  10. #10
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Allen,

    Perhaps we can automate some of this for you. Can you post a sample export and a finished formatted sheet to see how the data is manipulated?

    Maud

  11. #11
    New Lounger
    Join Date
    Nov 2015
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hope you don't need the formulae or other tabs but I've uploaded the sample of the LMS output and final report page after all my manipulations.

    --Allen

    .
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •