Hi Charlize,

I want the mail to be sent via Outlook, It's from work that the emails will be sent so I
guess exchange server.

I'm not sure my company would allow the use of cdo.(but i will confirm that)

Regarding setup: I have attached a file of my understanding to what you have said.
When you say "count the occurences of the department" will that count how many times London
appears or the amount of items that appear in London? I would like it to count the number of items
item with in each department.

yes I would have to send the mail to two address may be more, it would be just the one mail per
department.

Thank you for your time

Nurofen