I have a spreadsheet that needs to be sent to multiple people. I have created a button that when clicked will send it to all these people. The only problem is that I have used code where I am using a loop that iterates after it has sent to one person. The file i am sending is 6MB and this takes a while for each person. I want it so it sends to all people at once, without going through a loop. This can be done in email programs by using a comma to seperate each address e.g. hello@bt.com, me@bt.com, MD@bt.com. This doesnt work in vba though. The mail client is lotus notes.

Any help would be great,

Thanks.

Ant