Please help I need VBA code for sending emails

[drhassan]

Hi guys,

I just need a VBA code to send email (by outlook or other email client) with some data in records by using a button.

It would be great also (if it possible) to post an email template with attachment features that would be very helpful for newbies like me.

I'm sure guys that you would help me, therefore I have to thank you in advance

 

[theDBguy]

Hi. Maybe have a look here.

VBA - Send Emails Using Outlook Automation | DEVelopers HUT

A sample reusable VBA function which employs MS Outlook automation to send e-mails. Easily implemented within an MS Access database...

www.devhut.net

 

[Gasman]

Even look at Similar threads at the bottom of this thread.

 

[bastanu]

You mention "or other email client" so you might want to research the CDO method:

Sending Emails from Access with VBA and CDO

An extensive article describing how to send emails from within an Access application with VBA and the CDO Library.

codekabinett.com

 

[Uncle Gizmo]

I blogged about sending Gmail with VBA here:-

Gmail from MS Access, VBA, Excel, Word… - Nifty Access

Gmail from MS Access, VBA, Excel, Word… "Send a Secret Email" Escape From Outlook Video 1 (0:56) Escape From OutlookMicrosoft tightly combine their applications together however sometimes it’s nice to escape from Microsoft Products and use others. Here I demonstrate how you can use Google Mail...

www.niftyaccess.com

It was a long time ago, and some things have changed, but it should help you get started....

 

[drhassan]

Very amazing threads. It's also good to know those websites for any further MS access tips and templates.

Many thanks guys

 

[theDBguy]

Very amazing threads. It's also good to know those websites for any further MS access tips and templates.

Many thanks guys

Good luck!