Application.Dialogs(xlDialogSendMail).Show

Just a suggestion..I got this code using the macro recorder. If you're just
learning VBA it's really a great place to start.

BAC

"VBA Dabbler" wrote:

Does anyone know how to (using VBA) email a workbook? I want to populate
recipients, message, subject, etc. Is there a way to pull up the "global
address list" from Outlook for recipient selection?

Regards,
VBA Dabbler