Sending Email to Multiple Recipients

[Jonny]

I have some table , for example:

name | mail
------------------------------------
John Smith | John@gmail.com
Jack White | Jack67@yahoo.com
Mike Baker | mb1578@surfree.com

I'm trying to write some macro, when I press it opens new mail item or some text box. After I filling it (with some body), it sends it to recipients from a table with following format.

To: John Smith [John@gmail.com]
Subject: Waiting for your reply
Body: John, <my text>

or

To: Mike Baker [mb1578@surfree.com]
Subject: Waiting for your reply
Body: Mike, <my text>

Thank you , friends.

 

[Simon_MT]

How many records do you need to select and how do you select them?

Simon