Hi guys,
I need a macro that does 3 things:
1) rename 2 sheets based respectively on 2 cells (let's pretend they are cell "A1" for each sheet);
2) save them as PDFs and Mail the 2 PDFs through Mail (the Mac app);
3) send this mail to 3 different addresses, 2 of which are fixed while one should change according to the value of another cell (let's pretend it's "A2").
Is this even possible? I'm very new to excel and have no programming skill whatsoever, but I really need this workbook to work properly and this macro is way beyond my skills. Moreover, the only ones I've found online that are even vaguely similar to what I need use Outlook instead of Mail.
Thanks in advance for any help.
I need a macro that does 3 things:
1) rename 2 sheets based respectively on 2 cells (let's pretend they are cell "A1" for each sheet);
2) save them as PDFs and Mail the 2 PDFs through Mail (the Mac app);
3) send this mail to 3 different addresses, 2 of which are fixed while one should change according to the value of another cell (let's pretend it's "A2").
Is this even possible? I'm very new to excel and have no programming skill whatsoever, but I really need this workbook to work properly and this macro is way beyond my skills. Moreover, the only ones I've found online that are even vaguely similar to what I need use Outlook instead of Mail.
Thanks in advance for any help.