Hi
Is there a way to nominate the email address to be used as the sender.

We have mulitple mailboxes and rather than the From field showing the
individuals name we would like it to show a group mailbox name.

Is there a way this can be done using the sendmail method in excel.

If not does anyone have another way that we can send a workbook as an
attachment to mulitple people with a subject and nominating the from field.

Thanks
Noemi