How do you want the mail to be sent ? Is it by using your personal provider at home or is it through an exchange server ?

I'm using cdo (for short info messages because length is limited) to send automatic requests for more info based on rows that are partially filled in in excel (extra info for payments to be made that I need).

Regarding your set-up. It would be easier if every row in column A would have the department filled in (London, Whatever, ...). You just have to count the occurences of the department then.

Must the mail be sent to two adresses ? Seperate mail for each one or one mail for the two ?