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 files:
http://www.mytempdir.com/968938