send email through excel with different cell range in the body of the mail

i need a help on this....

i am trying to create an email sender via excel. what i wish is that when i click the send mail button, it will create separate email drafts for each unique email address in column B.


here's the tricky part... i want the table from column F to O be included in the email message... but only if the table column contains data.

so in my example file... it should create:
1 email for [email protected] and column f-o (row 4-7 only) should be included....
1 email for [email protected] and column f-g (row 8-9 only) should be included
1 email for [email protected] and column f10 -l10 should be included

*headers of the table should also be included....

the number of email addresses in column b varies from day to day.i will be using 3 different templates so if its possible when a user click on send email a box will appear asking him what template he would like to use...

really thanks in advance for the help

hope its not too early for me to bump this thread.. but i really wish someone could take a look into this? please?

No blank cells between 2 data in the table .

super thanks for this jaslake.

Have you had any progress on this dear?