

We hardcoded which column points to which email field. First, let’s do the admin stuff - declaration and point where the columns are. The mail subroutine reads information from excel sheet. Set up columns and create button Step 3: Mail subroutine Also, set a button which can trigger a mail macro. Use Columns A to E for email, cc recipient, bcc recipient, body text and title. If draftFirst is not “yes”, applescript will create the message and send it. Determine if we want to send the message (draftFirst).There should be 7 components after splitting. The main function we are interacting with is CreateMailInMailSierra which takes a string argument.

Once the applescript is inside, we can then get the macro to run it.

From another perspective, we are actually controlling Mail with Applescript.
