Email Automation | Save Variables

Questions & Suggestions
1

Hello everyone.

Here's my use case:

I need to send ~150 emails out for an event we're promoting. The names and email addresses are in a Numbers file. I want to create a KM Macro that copies the First Name and then the Email address from Numbers then pastes them into a new email message. I DO NOT want to automate the sending of because I will make slight personalizations to each message before it is sent.

I'm competent enough with KM to create many of steps in the macro (Selecting Menu item, activating the proper app, typing a keystroke, inserting text) but I'm a NEWBIE in my understanding of how KM handles variables.

Would someone provide insight on these steps?

  • Beginning in the "First Name" cell in Numbers. Copy value into "Variable One"
  • Tab to the next cell. Copy "email address" into "Variable Two"
  • Jump over to Mail and paste these values into the appropriate locations

What commands do I use to copy and then paste each of these variables?

Thanks in advance for your help.

Kevin

2

Hey Kevin,

Please post a copy of your spreadsheet with some dummy data, so we've got something to test with.

Number's is reasonably scriptable, so this shouldn't be too difficult.

  • What version of macOS?
  • What version of Numbers?

-Chris

3

Thanks for the reply Chris. I was able to figure out a solution in the meantime. Not very elegant but it worked.

Peace,

Kevin

4

You may do this task again sometime.

Post your test spreadsheet, and we'll figure out something more elegant for next time.

This task leverages to other tasks as well.