Excel sending data to Several E-mails

[dazzerwrestl]

Hi

I am new to this so hoping someone can help what I am looking to do in excel is create some code to send different users e-mails to different rows in a table.

I.e User A gets row A1
User B gets row B1

So I need to create something to send several E-mails at once but send row data rather then workbooks to each user

any help would be greatly Appreciated

[matthewspatrick]

What do you mean? For example, if A1 has 37 and B1 has 14, then UserA gets Row 37 and UserB Row 14?

[dazzerwrestl]

Sorry I prob did not explain this well for example user
joe bloggs needs to receive data stored on row a4 to i4
via e-mail as this relates only to them
user 2 Fred Perry needs to recieve data stored on row a5 to i5 I hope this now makes more sense

[matthewspatrick]

OK, clearer now. Is the email address stored anywhere?

[dazzerwrestl]

not at the moment but I can add this a column to the table with all the relevent e-mail addresses if need be