bhsoundman
Board Regular
- Joined
- Jul 17, 2010
- Messages
- 56
- Office Version
- 365
- Platform
- MacOS
Hi All,
I'm trying to get a script that will send a pdf to a specified list of email addresses from within Excel 365. The main kicker is that the Mac version doesn't function the same as a PC version. I've broken this down into 2 pieces.
1) Attached the pdf : If I go to the menu item "Share" in Excel then "Send PDF" it works great, but I can't seem to put that into a script. I've tried recording a macro, but it just comes up blank.
2) Create the email with the addresses & subject etc. This part I have done. I just need the pdf to attach to this email. Here's the formula I ended up with to make this work:
=HYPERLINK("mailto:?subject=Staff Meeting - "&D1&" - "&D2&"&bcc="&TEXTJOIN(",",TRUE,A2:B50),"Email Staff")
Anyone have any ideas? Thanks in advance!
I'm trying to get a script that will send a pdf to a specified list of email addresses from within Excel 365. The main kicker is that the Mac version doesn't function the same as a PC version. I've broken this down into 2 pieces.
1) Attached the pdf : If I go to the menu item "Share" in Excel then "Send PDF" it works great, but I can't seem to put that into a script. I've tried recording a macro, but it just comes up blank.
2) Create the email with the addresses & subject etc. This part I have done. I just need the pdf to attach to this email. Here's the formula I ended up with to make this work:
=HYPERLINK("mailto:?subject=Staff Meeting - "&D1&" - "&D2&"&bcc="&TEXTJOIN(",",TRUE,A2:B50),"Email Staff")
Anyone have any ideas? Thanks in advance!
