Sending Emails from Row data individually

Questions & Suggestions
1

Lets consider rows of data with only 2 columns in an Excel sheet, one named ‘NAME’ the other ‘Mobile Number’ so the name and Mobile Number is both in the same row but separate columns (horizontally on the same line).

Using KM I want to create and send an email for each line extracting the NAME and Mobile Number as a variable and placing them both into somewhere in the email both variables into the same email and then send it, then repeat the same email extracting data for each line in the Excel sheet.

Is this possible, if so how?

2

I use KM for a lot of standardised mails. I tend to work from .txt files and not Excel spreadsheets when it comes to my variable data.

Here's a quick-and-dirty example to get you started.

Keyboard Maestro “Sending Emails from Row data” Macro

Sending Emails from Row data.kmmacros (3.0 KB)

Keyboard Maestro Export.png1428×2286 386 KB