Generating PDF Payslips form Payroll in Excel and sending to Individual e-mails in Outlook

Hello People,

Please i need urgent assistance with the above subject problem.

We currently do not have a payroll software (one is being purchased soon) but i need to send payslips to over 500 recipients via email.

This is usually done manually and upon request but some form of legislation makes it compulsory to send to every staff same day they are paid.

Please assist urgently.

Thank you.

Hello 6StringJazzer,

Thank you for your response.

I have it all set up, Pay slips are generated directly from the payroll but i haven't figured how to send them to the email addresses all at once.

Where are the email addresses? It would be much faster if you provide a sample of what you have. Remove or change private data. With the information you are providing I can only give very general suggestions. If I have something concrete I can help you with an actual solution. What is your level of expertise with VBA?

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

I put my email address at the end of the table in the 2nd sheet. As regards my expertise in VBA, i'm a rookie. I just started learning in bits.

A sample file has been attached, thanx for your offer to assist.

PDF please.

I don't think i put the apostrophe you saw in the file but your point is duly noted. Thank you very much.

Wow, thank you very much. You just saved my team and I 24 man hours of work.

I need to learn how to do this, can you give me some pointers please?

I was able to do this for you in a fairly short time because I had adapted something I had already done that was very close.

I can answer specific questions about the code, but I have been using VBA for over 10 years, and I was a professional software developer before I went into management. So I can't teach you what I did in a forum post. It would take me hours. But I can answer questions.

Oh yeah. I'll come back to you when I have questions.

Your assistance is highly appreciated.

Thank you.

Hello 6StringJazzer,

I added a few more payroll items in the payroll sheet, meaning more columns. The solution is no longer working.

I keep on getting the error message:

Run-time error '-2147467259 (8000405)':
Outlook does not recognize one or more answers.

What can i do to correct this?

Thank you.

Where did you add columns, in the middle of existing columns, or at the end? The code depends on expecting certain data to be in certain columns, and if you inserted columns in the middle, the data is no longer in the columns where expected.

The code builds the email address by taking the name from column B and the email address from column BO to create a string

Firstname Lastname <[email protected]>

If that data is no longer in the same columns, you will get an illegal email address. I'll bet you copied the error message wrong and it is probably "Outlook does not recognize one or more names."

If the columns changed you need to update this part of the code:

Please Login or Register  to view this content.

Perfect, the code has been updated accordingly and works perfectly, thank you. You got the error message correct too.

If i want to change the body of the mail to read thus,

Dear XXXX,

Please see attached your payslip for October 2018.

Regards,

How do i go about it?

I just wanna say thank you to 6StringJazzer.
I was exactly looking for something like this code. I hope figure it out when I change the data , and payslip to my version.
If iI face some problem can I ask from you ?

Thanks

Dear 6StringJazzer,
I use your code to write my payroll. I'm having a loop error like below. I have attached the file, can you please check it for me?

formProgress.Label1 = ""
formProgress.Show //// It's a loop here, and not run the next step if you don't close it.
Application.ScreenUpdating = False

Capture.PNG

Originally Posted by huyenkim10116

Dear 6StringJazzer,
I use your code to write my payroll.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Originally Posted by 6StringJazzer

I was able to do this for you in a fairly short time because I had adapted something I had already done that was very close.

I can answer specific questions about the code, but I have been using VBA for over 10 years, and I was a professional software developer before I went into management. So I can't teach you what I did in a forum post. It would take me hours. But I can answer questions.

Thank you so much for this🙏. I have the same difficulty, and I've searched online for results but to no avail.. this has helped me a great deal.
And to think this question was answered 4 years ago😄 thanks Akintomiwa