Emailing Out Automatically From Access

[main-man]

Hi i have recently started a new job and require immediate help if possible!

Im not an expert in using MS Access but know bits and bats.

I have a list of emails which i can send to a excel spreadsheet but how do i go about automating the database so once it receives an email address with a click of a button it will send an email out with an attachment. Rather than having to manually write each email and attach a document. we also use MS Outlook?

Could some one please help me?

many thanks

 

[KenHigg]

The outbound email part can be done with a 'SendObject':

DoCmd.SendObject acSendTable, "Employees", acFormatXLS, _
    "Nancy Davolio; Andrew Fuller", "Joan Weber", , _
    "Current Spreadsheet of Employees", , False

Hope this helps.

 

[reclusivemonkey]

Man, Nancy and Andrew sure do get around ;-)

 

[KenHigg]

As does Joan

 

[main-man]

Thanks Ken I Will Try This!

 

[KenHigg]

Here's the rest of the 'Help' if you need it:

http://msdn.microsoft.com/library/d...baac11/html/acmthactSendObject_HV05186513.asp