Sending e-mails from Excel using VBA

[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

 

[Doug Robbins - Word MVP]

Hi Stosh,

For anything to do with programming Excel, you should post to
microsoft.public.excel.programming. This group is for using vba in Word.

You might however take a look at the article “How to send an email from Word
using VBA” at:

http://www.mvps.org/word/FAQs/InterDev/SendMail.htm

as you might be able to apply that information to Excel.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP