Auto emailing in the BCC column

Dear All,

A bit stuck. I have created a workbook that searches for a list of operators dependant on search criteria.
Then emails them a range that we edit.

The problem comes when the email sent needs to be in a different format.
I need help editing the macro so all the email addresses that come up in the search fill the BCC list in 1 email instead of 1 email per address.

I can then .Display the email and put the more complicated body in manually and only have to send it once to everyone.

Please Login or Register  to view this content.

I have attached the file.
Any help is appreciated

Tom

TMShucks,

Thats brilliant,

thank you
Tom