PDA

View Full Version : Excel sending data to Several E-mails



dazzerwrestl
07-30-2007, 04:30 AM
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
07-30-2007, 05:59 AM
What do you mean? For example, if A1 has 37 and B1 has 14, then UserA gets Row 37 and UserB Row 14?

dazzerwrestl
07-30-2007, 06:18 AM
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
07-30-2007, 06:20 AM
OK, clearer now. Is the email address stored anywhere?

dazzerwrestl
07-30-2007, 07:30 AM
not at the moment but I can add this a column to the table with all the relevent e-mail addresses if need be