Question about AppleScript to automate messages

Since I wrote the original script, I guess it falls to me to update it :)

> Instead of fixed message, I'm trying to add the following line to the code so the script will read column c (or multiple columns) in excel that contain the actual message however I'm not able to return the value and add this to the message body.

The way the original script works is that there is one handler, get_member() that extracts the data from Excel.

You just need to expand this handler with any other commands to get the additional data.

In this case since you also want the content in column C, add something like:

		set _messageText to value of cell ("C" & id)

etc., for as many cells as you need - just create a variable name and the appropriate column reference.

Once you have this, you just need to include it in the data that the handler returns to the calling script:

		return {name:_name, number:_number, msgText:_messageText}

Now the script will pass back three pieces of data instead of the original two.

Now the second handler that actually sends the message, send_message_to() can reference the additional values since they're passed into the handler in the member variable:

	tell application "Messages"
		try
			send ("Hello, " & name of member & ", " & msgText of member) to participant (number of member) of account "SMS"
		end try
	end tell

> Also I'm not able to figure out how to use iMessage service only.

Do you mean you only want to use iMessage and not SMS. That's a matter of changing the 'account' parameter of the send command to use another account.

If you don't know the names of the accounts you can use, run the following script:

tell application "Messages"
	get description of every account
end tell

now you'll see a list of the names of configured accounts ,Just substitute the one you want to use.