Hi

I am using a macro to drop completed workbooks, or parts of completed
workbooks into an email, using Application.Dialogs(xlDialogSendMail).Show.

As the various mails are sent to specific groups or department mail box's I
would like to have the To: and CC: fields completed automatically. Can this
be acheived from the macro run in excel.

Thanks
Richard