Email

[jer]

Hi
Is there any way where I can have a command button on my form which will allow me to send a report via an email attachment. Also when pressing the button, is it possible for a list of contact or a message prompting for an email address to be entered to pop up?
Any help will be appreciated!
Thanks in advance
Jer

 

[vbaInet]

Have a look at DoCmd.SendObject

http://www.fmsinc.com/microsoftaccess/email/sendobject.html
http://msdn.microsoft.com/en-us/library/aa220736(v=office.11).aspx