+ Reply to Thread
Results 1 to 20 of 20

Launch outlook and Email specific range of cells

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Launch outlook and Email specific range of cells

    I am looking for a Macro that will launch outlook and email a specific range from my spreadsheet in the body of my email.

    Thanks

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    What range?

  3. #3
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    a1:L200

    Also I want to attach the spreadsheet to the email

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    The same workbook every time?

    If it not the same every time do you want to select in before the macro is run or once the email pops up?

  5. #5
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    it is the same workbook everytime

  6. #6
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    Try:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    That works great...Thank you.

    Is there a way that I can set a specifc time to send this daily, even if excel is not open??

  8. #8
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    If you are using Windows 7 click the Start button and type Task Scheduler into the search bar.

    The task scheduler should help you with that part. You can do it two ways:

    1. Use the scheduler to send the email (It may be difficult to do this with the spreadsheet in the body of the email)

    2. Put the macro in the workbook_event and use the task scheduler to open the workbook.

  9. #9
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    thats great. One other issue I am having is that I have distribution lists set up in outlook. How do I get the email to go to those recipients?

  10. #10
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    Describe your distribution list. Is it:

    1. A list on a spreadsheet
    2. Set up by yourself in the contacts tab
    3. A mail server distribution list set up by your LAN server group

  11. #11
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    2. Set ub ny myself in the contacts list, used names from my Lan server group to do so.

  12. #12
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    I believe you should be able to put the name of the Contact Group here:

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

  13. #13
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    I did attempt to do that, but this doesnt seem to be working

  14. #14
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    I just tested it with a Contact Group (is that what you mean by distribution list?) and it worked fine for me.

    I'm assuming your on Outlook 2010 also? Are you sure you have the name of the Contact Group spelled correctly?

  15. #15
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    yes, it is outlook 2010, and yes I am referring to a Contact Group. Just attempted again. When I put the name of contact group, it does not send an email.

  16. #16
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    Is it possible to have the selected range be sent in the body of the email as a picture, so that is readable on a blackberry?

  17. #17
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    Are you including it in quotes? It worked fine for me.

  18. #18
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    You might have to redact any sensitive information from your workbook and attach it so we can see the code in context.

  19. #19
    Registered User
    Join Date
    09-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Launch outlook and Email specific range of cells

    Here is my Code

    Please Login or Register  to view this content.
    Last edited by Jvollmer33; 09-20-2013 at 07:05 AM.

  20. #20
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Launch outlook and Email specific range of cells

    When posting code please use code tags. To use code tags highlight the code and press the # button in the toolbar.

    I don't understand. The code posted has an email address not a contact group.

+ 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. VBA to select a Range of cells as Email Body In Outlook
    By TC922 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2013, 11:06 AM
  2. [SOLVED] VBA Code to select Range of cells as Email Body In Outlook
    By naveenmarapaka in forum Outlook Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2013, 06:43 AM
  3. Add to Excel from Outlook when a email body contain a specific test
    By mathewfer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 02:52 AM
  4. 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
  5. Email specific range of cells using .htmlbody
    By Jason Smith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-19-2008, 03:01 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