There is a provision for this already. If you look at the thread http://www.excelfox.com/forum/f18/se...email-ids-304/, you'll find that the sub-routine in the attached file has a Range argument that needs to be included in the body of the mail. See if you can play around with it. If you aren't able to modify it what you are looking for, post back.

And please follow the rules of Cross-Posting. There is a reason why such rules are in place. If you have posted this query any other place, please post that link too here.

VBA Loop to Auto Send Emails; Pull in More into Body