Mass Email - Based on Attachment - SMTP (1 Viewer)

[joshirohany]

Hello Experts,
I have a database where i am suppose to email individual payslip to employee around 900 a month . But challenge is, can we do it without ms outlook. I want Access should directly use SMTP and send email without using outlook.

I have folder where all payslip are stored.
Payslip names are on the Employee Code.

Expert help is appreciated.

 

[ebs17]

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

 

[joshirohany]

Thanks for the reply. But can someone help in designing. Since i dont know VBA.

Also how to send in bulk?

 

[arnelgp]

Also how to send in bulk?

you can't, only 1 by 1.

 

[ebs17]

Since i dont know VBA.

This would be a good reason to change that.
Either you adapt your skills to your requirements, or you look for a developer who will do the work for you, usually for a fee.

 

[The_Doc_Man]

Also how to send in bulk?

Sending "in bulk" only works if everyone gets the same exact payslip. I'm betting that you don't have that situation. More likely, you will have to build each unique message one at a time and send it one at a time.

Just as a hint, look at the threads listed in the "Similar Threads" at the bottom of this page. They seem relevant. And I concur with the advice to use CDO, which means you will have to learn a little bit of VBA programming to build the messages and send them.