sending email via vb in excel..

L

ldb

Is there any quick and dirty way to send an email thru
outlook via an excel vb macro?

When I use the Application.Dialogs(xlDialogSendMail).Show
it brings up outlook & waits for me to hit the 'send'
button.

Any easy way to specify the file to attach to the email,
address, and have it automatically sent?
 

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

Dialogs(xlDialogSendMail).Show - how to delete attachment? 2
Sending Excel Worksheet as PDF file with Excel 2007 3
Excel Files to be sent out via Lotus Notes 3
Need to fix macro to send workbook via email 1
Email 4
open outlook and add email address 5
excel programming 4
Thru VBA, how do I e_mail with ONLY ONE CLICK ? 1

Top