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

joshirohany

Registered User.
Local time
Today, 06:39
Joined
Apr 3, 2019
Messages
33
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.
 
Thanks for the reply. But can someone help in designing. Since i dont know VBA.

Also how to send in bulk?
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom