auto email from excel

[ajking]

In Access I set up a Command button that would auto email a document, works fine. Is it possible to set a command button in Excel to do the same. I want to set up an excel form that can be emailed automatically once the form is completed and they click the command button. TIA

 

[Dreamboat]

As an attachment or as part of the message body?

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[PepeLeMokko]

You can also send your entire workbook ( which is or is not reduced to a form) by VBA using the "SendMail" Method

 

[ajking]

many thanks for the prompt replies!

Dreamboat: I want to send it as an attachment

PepeLeMokko: I used sendmail in Access so I presume the coding is the same?

ancillary question: I have to assume that senders may be using Outlook or outlook express, would this cause any problems?
regards

Alan

 

[bearjam]

Beware of Outlook webmail, it has dampened many a spirit where the MAPI client is involved. Not sure if this would effect you though.