I use the macto CMDINVIA_CORPORATE for many my application...
Now, this macro send e-mail a user in column C with various notice, my prob:
Inested to send the value of variable to a single user is possible:
Matching the value in range H:N of sheet CORPORATE with the range column H
of GAF and if is present in the and send all line of sheet GAF to the user in
column D do until the value of matching matching finished...

Finished the matching for user OI34573, use the same tecnique with OI35475,
ecc...

i have attached a report to use in standard mode for each user...

Hope understand me.
Naturally if have other suggestion....

here the file:
http://www.mytempdir.com/968938