Email from a Form the content of a Record

[cbayardo]

I want to have a button on a Form that when it is clicked, it creates and
sends and email with information on the record that it is on. I want it to be
an attachment if possible. A report type attachment. Is sendobject the only
option? Can you have a search criteria?
Thanks

 

[Daniel]

Sendobject is the simplest. Attachement? what type of attachements? If it
is for an object within your db (report,table, query,...) then sendobject is
your best method. Otherwise, you need to look into automating Outlook. For
that take a look at:

http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

What do you mean by "Can you have a search criteria?"?

Those are your 2 best and simplest method. however there are more available
to you as a programer. take a look at the following link for more options.

http://www.granite.ab.ca/access/email.htm