Sending E-mails from within Excel

[Munich]

I have an icon in an excel file that has a macro associated with it that executes the "Send To - Mail Recipients (As Attachment)" function.

Basically Application.Dialogs(xlDialogSendMail).Show

I there a way to use this command and have the To field in the resulting e-mail automatically filled in? (And while asking, the Subject field too?)

Thanks in Advance

Ernie
Munich

 

[DominicB]

Good morning Munich

I don't believe there is. You could try Ron de Bruin's SendMail add-in for all kinds of extra mailing functionality, but only for Outlook (/Express) - you don't say which client you're using.

http://www.rondebruin.nl/mail/add-in.htm

HTH

DominicB

 

[Anthony47]

I owe these two methods to previuos discussions here on mrexcel forum:

Either
ActiveWorkbook.SendMail Recipients:="ask@mrexcel.com", Subject:="Hi"

Or
Application.Dialogs(xlDialogSendMail).Show _
arg1:="ask@mrexcel.com", _
arg2:="This goes in the subject line"

Bye,

 

[Munich]

Anthony47,

Thanks.

Both sets of code work great. I makes a 360 feedback tool work that much better now.

Ernie