Sending E-mails from VBA

S

Stosh7

I would like to automate an e-mail response using Excel workbook data with
some calculations.

VBA has a SendMail statement which will send a workbook as an attachment,
but I haven't found way to write to the body of an e-mail. There is a Built
in dialog, however ,the same issue exists. SendKeys doesn't write to an open
dialog.

It seem that there should be an easier method than calling Outlook (or
Express) or some other, large external application. Might there be a utility
out there?

Any suggestions ?

TIA,

Stosh

Office XP, Windows XP Pro
 

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 e-mails from Excel using VBA 1
CTRL + END function to VBA - Inside an e-mail 0
Sending e-mails from specific email address 2
VBA about sending e-mail automatickly 1
Emailing a sheet from a workbook with VBA 0
Sending E-mail from an account that is not logged in 4
Sending e-mail from other account 1
E-mail excel attachment via Lotus Notes 0

Top