Sending Workbooks via Email

G

Guest

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
 
G

Guest

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
 
G

Guest

Ron,
Thanks for the referral to your website - it was very helpful.
Regards,
VBA Dabbler
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending a selection by email 5
Sending Excel Workbooks to Outlook people automatically 1
email via userfrom? 5
Excel 2007 Routing workbook to Outlook 1
Custom Document Properties in Word documents and Excel workbooks 13
Excel VBA using Sendmail to Send to Distribution List 1
Need to fix macro to send workbook via email 1
How do I move multiple Worksheets between Workbooks using VBA ? 7

Top