Bookmark this site, this shows how to do it in Excel
http://www.rondebruin.nl/mail/add-in.htm

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Bip" wrote in message ...
Is there a simple way of getting a set of data emailled directly to
me through a SUBMIT button?
I have an Access form that gives easily selected answer choices. I want
the form to be able to use a button that I found in Microsoft Publisher
which submits via email directly to me.

How do I do this in Access or maybe in Excel?

Jonah