Thanks to dwlerwill I managed to get excel to automatically email a workbook, however, I was sending the wb to a defined group of four recipients and I just used the group name as the recipient. The email just came back to me because the recipient name was not found on the email server. I expected vb to just recognise the group name and send to the four names within the group. Am I being too expectant?
Could someone please enlighten me.
TIA
Ezzer...
Could someone please enlighten me.
TIA
Ezzer...