Here is what I am trying to do:

I am looking for a method to automate sending the results of a list out
to a set of individual email addresses in an adjacent list.

My worksheet has values in A:H
G is called from a VLOOKUP list based on the value that is entered in
C.

So for all rows that contain adjacent matching values (names), in
column G, I want to select those rows and copy and paste that
information into an email to the person in G.

I want suggestions for the best approach to this. I was thinking either
a macro, or something 'underneath' the excel worksheet that could
accomplish without having to make excel click on an email address and
copy and paste data in to separate emails.

Thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/