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.
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 theicon 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!)
Thank you so much! That makes far more sense.
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.
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
So, what's the syntax for opening workbooks on a MAC? The code above is for Windows.
I do not know why you have changed this line:
for this one:Please Login or Register to view this content.
in your workbook. You must change it back.Please Login or Register to view this content.
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
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks