+ Reply to Thread
Results 1 to 8 of 8

Macro to send individual tabs from a worksheet to different email address based on in

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    san diego
    MS-Off Ver
    2011
    Posts
    4

    Question Macro to send individual tabs from a worksheet to different email address based on in

    (source)
    I'm not quite sure what I'm doing wrong but i I get the "Please activate the data sheet to parse/email and then run this macro. Aborting." message every time. I am always on the supplier sheet so it is the active sheet. I made some minor code adjustments to fit my needs but i don't see why they would be effecting it. here it is:

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 06-28-2014 at 03:13 AM. Reason: Added missing CODE tags, moved to own thread. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to send individual tabs from a worksheet to different email address based on in

    That original code was meant to be stored in and run from a workbook OTHER than the incoming data sheets. Sounds like you stored the macro in the data file.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    06-27-2014
    Location
    san diego
    MS-Off Ver
    2011
    Posts
    4

    Re: Macro to send individual tabs from a worksheet to different email address based on in

    Thank you so much! That makes far more sense.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to send individual tabs from a worksheet to different email address based on in

    As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
    FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.

  5. #5
    Registered User
    Join Date
    06-27-2014
    Location
    san diego
    MS-Off Ver
    2011
    Posts
    4

    Re: Macro to send individual tabs from a worksheet to different email address based on in

    Sorry to have to reopen this but I went through it again and can't seem to get it to work.

    I keep getting this: “object doesn’t support this property or method”. I have attached the workbooks so that you could take a closer look. Once again, thank you so much for your help!

    Workbook Paths:
    1. Macintosh HD:/Users/meastman/Dropbox/TekWorks/Current Projects/automate income emails/WeeklyIncoemReportsTest.xlsm
    2. Macintosh HD:/Users/meastman/Dropbox/TekWorks/Current Projects/automate income emails/Suppliers.xlsm

    Suppliers.xlsm

    WeeklyIncomeReportsTest.xlsm

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to send individual tabs from a worksheet to different email address based on in

    So, what's the syntax for opening workbooks on a MAC? The code above is for Windows.

  7. #7
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Macro to send individual tabs from a worksheet to different email address based on in

    I do not know why you have changed this line:
    Please Login or Register  to view this content.
    for this one:
    Please Login or Register  to view this content.
    in your workbook. You must change it back.

    I do not see how this income reports workbook will correspond to this code. Is it correct workbook?

    Biggest problem will be that you may not use CreateObject("Outlook.Application") on Mac. There is code for Applescript here: http://www.rondebruin.nl/mac/macmail/macoutlook1.htm
    Last edited by Izandol; 06-30-2014 at 06:15 PM.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  8. #8
    Registered User
    Join Date
    06-27-2014
    Location
    san diego
    MS-Off Ver
    2011
    Posts
    4

    Re: Macro to send individual tabs from a worksheet to different email address based on in

    Wow. That must be a change that happened while I was trying different things out. I thought i had switched it back. My bad.

    Alright I will try to combine these two macros and see if i can get it parse and email on my Mac.

    I am not sure exactly how the Suppliers spreadsheet containing the macro is calling the WeeklyIncomeReportsTest workbook, I am also not sure how it parsing the workbook based on what is in the nick-name column. I'm sorry for my inexperience here. Still learning. Do I need to insert any code into the WeeklyIncomeReportsTest workbook?

    thanks again!

+ 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. Replies: 11
    Last Post: 05-26-2013, 07:45 AM
  2. Want to send individual tabs of a worksheet to different email addresses
    By billbirch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2013, 07:38 PM
  3. Send email to address (in cell)l and individual pdf files (in cell)
    By oc2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-19-2012, 06:51 PM
  4. Replies: 6
    Last Post: 12-02-2011, 02:14 PM
  5. VBA code to look up email address and send worksheet
    By JSB0009 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2010, 10:29 AM

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