Email with MS Access 2003

[★ freakmonger]

I'm creating a database in MS Access 2003 and need to e-mail when I button is clicked.

 

The e-mail will be a preset e-mail and will pull information from data fields. (email, status, completed, forwarded to, etc)

 

I've looked around but can't seem to find code that works.

 

anyhelp would be greatly appreicated!

 

thanks!

[JoWie]

Easiest solution would be opening a mailto: link from VBA.

 

Another is implementing SMTP in VBA.

[🜲 Samapico]

Easiest solution would be opening a mailto: link from VBA.

 

Another is implementing SMTP in VBA.

Opening a mailto link wouldn't send an email, it would just open up outlook or whatever...

[JoWie]

Easiest solution would be opening a mailto: link from VBA.

 

Another is implementing SMTP in VBA.

Opening a mailto link wouldn't send an email, it would just open up outlook or whatever...

 

That is why I gave both options

[🜲 Swift]

Just go with Microsoft Sharepoint if you wanna do something like this

[★ gallitin]

Why access? If wiling to go with a ms SQL express version would be easy to accomplish with an SSIS package. If so let me know I coil create one for you.