Email

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 27 Sep 2007 08:30 GMT

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

Reply to this Message

Bob Phillips - 27 Sep 2007 09:36 GMT

This dialog takes 3 parameters, recipients, subject and return_receipt.

So you can use

Application.Dialogs(xlDialogSendMail).Show
"bob@mydomain.com,richard@somewherelse.com","Work update"

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi
>
[quoted text clipped - 10 lines]
> Thanks
> Richard

Reply to this Message

Richard - 27 Sep 2007 14:48 GMT

Apologies I hope I'm not being totally thick, but I now get the following:

Compile error:
Expected: line number or label or statement or end of statement

> This dialog takes 3 parameters, recipients, subject and return_receipt.
>
[quoted text clipped - 17 lines]
> > Thanks
> > Richard

Reply to this Message

Bob Phillips - 27 Sep 2007 14:54 GMT

Probably wrap-around, try

Application.Dialogs(xlDialogSendMail).Show _
"bob@mydomain.com,richard@somewherelse.com","Work update"

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Apologies I hope I'm not being totally thick, but I now get the following:
>
[quoted text clipped - 23 lines]
>> > Thanks
>> > Richard

Reply to this Message

Richard - 27 Sep 2007 15:14 GMT

That is fantastic and suits me just fine. Thanks very much

> Probably wrap-around, try
>
[quoted text clipped - 28 lines]
> >> > Thanks
> >> > Richard

Reply to this Message