Emailing Spreadsheet with Macro?

[broxanne]

Hi,

I am in need of a macro that will e-mail a spreadsheet to anyone's email. I have a macro that will send an attachment from excel to an email account, but I am in need of a macro that will pose the excel sheet directly to an e-mail.

Can anyone help me with this!!??


I appreciate the help!

[Paul]

You didn't post the code you're currently using, but you should be able to use the same code you're using now with a slight change near the end:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

This will show you the e-mail on-screen and you can then insert an address as you please.

[broxanne]

Sub Email()
ActiveWorkbook.SendMail recipients:="julsn@yahoo.com"
End Sub



This is the macro I am currently using to e-mail an excel spreadsheet as an attachment to someone's email address.

Something just needs to be added to this in order to send it as an e-mail and not an attachment??

Thanks so much for your help!

[Paul]

Per Ron deBruin's great site (http://www.rondebruin.nl/mail/folder1/mail2.htm),

With SendMail it is not possible to :
1) Send text in the Body of the mail
2) Use the CC or BCC field
3) Attach other files

There are a number of examples on his main VBA e-mail site (http://www.rondebruin.nl/sendmail.htm) that will do this using the Outlook object model (body).

Hope that helps!

[broxanne]

Thanks much! I will try it out.