send mail button

[eHanSolo]

hi all,

I'd like to send an email, maybe from excel with a macro attached to a button that would automatically send an email once a few fields have been filled in.

is this possible at all?? ...any help would be greatly appreciated.

thanks.

e

 

[mp9]

ActiveWorkbook.SendMail recipients:="Tom Test" will send a copy of the active workbook.

Alternatively, the Outlook-based code at

http://www22.brinkster.com/accessory/modules/005.shtml

should work in Excel with a few adjustments (it's written in VBA for Access).