Sending a workbook with a message

M

MacroMan

Hello, I hope someone can help me out on this please.
I am using VBA in Excel XP with Windows 2000.

I need to send a workbook via e-mail as an ATTACHMENT. The
user would run the code from Excel. Can this be done using
the built-in dialog 'xlDialogSendMail'? It works great as
far as adding the workbook as an attachment, adding the
address line and the subject line. My example code follows:

Set oMessage = Application.Dialogs(xlDialogSendMail)
oMessage.Show "(e-mail address removed)", "subject line"

The only problem is, I want to add a message along with
the attachment and I need it to actually SEND the email. I
can't seem to get it to do this. If this is not THEE way
then what is the most efficient way?

Your sample code would be most appreciated...
Thanks in advance...
 

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
Excel Files to be sent out via Lotus Notes 3
Sending Excel Worksheet as PDF file with Excel 2007 3
Add pdf attachment to new mail 7
excel programming 4
Need to fix macro to send workbook via email 1
Thru VBA, how do I e_mail with ONLY ONE CLICK ? 1
Modifying an Excel 2000 Macro 4

Top