GENERATION OF PAYSLIPS AND EMAILING THE SAME TO EMPLOYEES

[PHIRIM]

Dear forum members,

We have a database that has been working very well to generate payroll reports including payslips. We have been printing these payslips but a need has arisen for us to start generating them and at a click of a button, admin sends the same to all employees.

Kindly guide me, i'm a novice and ready to learn

Thank you all in anticipation

 

[Minty]

Crossposted here:

Auto generation and sending of payslips to employees in the database

Dear Forum members, I have a database that we are using to generate payroll reports including payslips. So far, we have been printing them. What steps do i need to take to allow for generation of payslips, and at a click of a button, the payslips be sent to employees' email addresses? I thank...

www.accessforums.net

 

[CJ_London]

instead of printing to a printer, print to pdf - you’ll need to provide a path and file name which will need some sort of unique id such as employee id and the period the payslip covers

The rest of it all depends on what your tables look like and contain.

 

[CJ_London]

Cross post noted - I’ll leave it to the other forum as I don’t want to duplicate suggestions.

I would just point the OP to the similar threads at the bottom of this thread

 

[arnelgp]

cross posted here:

Auto generation and sending of payslips to employees in the database

Dear Forum members, I have a database that we are using to generate payroll reports including payslips. So far, we have been printing them. What steps do i need to take to allow for generation of payslips, and at a click of a button, the payslips be sent to employees' email addresses? I thank...

www.accessforums.net

 

[Gasman]

I thought I was having deja vue there for a moment, as I am sure this exact question has recently been asked?, presumably by another person, as bot this and their crosspost was only posted today?
NB, I have cossposted this post.

Edit: I believe this was the one I was thinking of.

 

[The_Doc_Man]

@PHIRIM - you see comments in this thread about cross-posting. You have said you are a novice, so I will explain.

When you post the same question on two different sites, that is cross-posting. We strongly urge people to not cross-post, but we also understand that if you are not getting answers, you start "shopping around" to see if you can get better results. The problem with undiscovered cross-posting is that if you have done that, we have no easy way to know if your problem was solved and therefore might end up wasting the time of our volunteers to try to solve your problem independently of an already existing solution.

To mitigate this problem, if you DO cross-post but then include a link to the other article, we can at least see if you have an answer before we waste our time reinventing a wheel. If you at least notify us and post a link then it shows you are aware that you are taking up the time of volunteers who do not get paid for what they do.

As to your specific problem, I have a more political/government question for you. Some governments restrict sending private or personal information over unencrypted e-mail. Your IP address says you are from Zambia. Your location is not a problem with us, but we don't know the government regulations that protect your people's privacy. Please check with appropriate authorities to verify whether legally you CAN send personal data in the way you intended.

 

[Isaac]

Hard to tell if PHIRIM even saw your post. If so hopefully he/she heeds "the same"

 

[PHIRIM]

@PHIRIM - you see comments in this thread about cross-posting. You have said you are a novice, so I will explain.

When you post the same question on two different sites, that is cross-posting. We strongly urge people to not cross-post, but we also understand that if you are not getting answers, you start "shopping around" to see if you can get better results. The problem with undiscovered cross-posting is that if you have done that, we have no easy way to know if your problem was solved and therefore might end up wasting the time of our volunteers to try to solve your problem independently of an already existing solution.

To mitigate this problem, if you DO cross-post but then include a link to the other article, we can at least see if you have an answer before we waste our time reinventing a wheel. If you at least notify us and post a link then it shows you are aware that you are taking up the time of volunteers who do not get paid for what they do.

As to your specific problem, I have a more political/government question for you. Some governments restrict sending private or personal information over unencrypted e-mail. Your IP address says you are from Zambia. Your location is not a problem with us, but we don't know the government regulations that protect your people's privacy. Please check with appropriate authorities to verify whether legally you CAN send personal data in the way you intended.

Good evening,
Sorry for cross-posting. Indeed, it is wasting time to post in so many groups as the volunteers won't know if a solution has been provided, i am sorry for this.
However, let me address the issue of sending of personal information, actually we have a lot of laws that protect people's privacy. I have no intentions of sharing such protected data, what i thought of is that if i have to share anything, it will be the structure of the tables in the database with some fictitious data
I am ready to be guided further

Kind regards

Phiri M
+260974936864

 

[PHIRIM]

Good

instead of printing to a printer, print to pdf - you’ll need to provide a path and file name which will need some sort of unique id such as employee id and the period the payslip covers

The rest of it all depends on what your tables look like and contain.

Good evening
Thank you for your guidance. As earlier indicated, i am a novice and thus when you say 'provide a path and file name', i am not sure where to put the same

Please guide me

Thank you

Phiri M
+260974936864

 

[Gasman]

Try looking at that link I posted?

 

[CJ_London]

Thank you for your guidance. As earlier indicated, i am a novice and thus when you say 'provide a path and file name', i am not sure where to put the same

You have asked a vague question- so we can only provide vague responses

A path is a path to a windows folder such as
C:\myDatabases\payroll\payslips

A file name might be something like

[employeeID][period].pdf

Where to put it? Wherever you currently print your payslip - I assume you are using docmd.outputTo rather than manually printing your payslips

And look at the link provided by gasman in post #6

 

[Isaac]

I'll repeat something I've said to so many I wish I had a template for it.

You are a beginner in these areas and trying to make an enterprise-grade database for your company at this stage in your knowledge is a terrible idea, and you wouldn't do it in any other context. First you learn and practice, then you deploy something your company is going to trust and depend on.

You wouldn't try to perform a surgery on your first day in med school.

Why do some people think it's normal to do that same thing in tech?

First learn the basics of a Windows computer. Then learn about Microsoft Access in general. Finally, learn VBA. Then you try to code what you need in this case and if you fail, post a question to a forum explaining what you've tried and people will be glad to help.

One of the trends in the last 10 years that led to the attitude is the combination of "don't re-invent the wheel" as a first principle and the proliferation of open source code. I see even experienced programmers laughing at a newbie for trying to figure out how to work with a socket for eg and telling him "there's this library or that code from that software that would do all that for you, no point in trying yourself". This is especially dangerous for fresh programmers, since they often don't get to learn much of anything except gluing code together, and would have no courage digging into it when there are problems or when improvements are needed.