DoCmd.SendObject (E-mail)

[Guest]

I know how to do a DoCmd.SendObject from Access but I need to do it from
Excel. What I have setup 5 sheets that feed a sheet that only gives me the
data that I need for an E-mail that I must send out every day. The E-mail
MUST be text only. I can do this in Access and it works great with the CMD
BTN that has a [Event Procedure] that does the DoCmd.SendObject. Can I do
this same thing on the Report sheet so that the user can just click the CMD
BTN and it will put the data in a n E-mail.

Thanks

Keith

 

[Les Stout]

Hi KAnoe,

have a look at Ron de Bruyns site

http://www.rondebruin.nl/sendmail.htm

Les Stout