How to send a mail from Access?

[Guest]

Hi,

I have designed an Access database. I should like to implement the
possibility to send an MS Access table - with a click on a button - to a
another user for further processing in his database. How will the code look
like?

I will be very greatful for any possible help! I'm using Office 2003.

 

[Arvin Meyer [MVP]]

The easiest method is to use SendObject, either through the File menu in the
interface, or using VBA code from a button. You can find an example in my
demo database:

http://www.datastrat.com/Download/EmailSenate2K.zip

The code download page on the same website has several more methods using
Outlook.