Email
This dialog takes 3 parameters, recipients, subject and return_receipt.
So you can use
Application.Dialogs(xlDialogSendMail).Show
","W ork update"
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Richard" wrote in message
...
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
|