Super thank you sir you do not know how much you made my work easier from making payslip manually for two days after payroll to one day only thank you never stop doing such videos very simple and concrete explanation

Big thank you sir, your video made my task much easier.

Really helpful tutorial. I subscribed!

Great work,

Thank you very much once again.

Great vb code. I have saved a lot of time. 😀 Thank you

very helpful. thank you.

Ek no. Bro thank you so much❤

Thankyou sir for this lesson

Thanks man

Really appreciated, such a helpful tool, if possible, I would like to know how to design more attractive body email.

Thank you very much for the video, it is really helpful. Can you pleas help me to deal with the case where the employees have left and there is no continuous employee ids?

Thank you very much for the video, Can use Gmail instead of outlook?

hi. Our company does not use the outlook email client but use lotus notes email client instead. Will it be possible to do this with lotus notes also? Your reply will be very much appreciated.

I have a problem on this. When i click F8 "Sheet1.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & "\" & Filename". I'm encountering an error that says " Document not saved. The document may be open, or an error may have been encountered when saving"

Thanks sir ji

if someone's Traveling Allowance is ZERO then i want to his whole RAW would be deleted. is it possible ? I don't want to show him/her if he/she don't get that allowance.

sir, when i test the program there is an error massage Run Time Error '438': Object doesn't Support this property or method (Attachment Add). on reference I use outlook 14.0 object library. is it only supported by microsoft outlook 16.0 object library?

please can you show me me from the beginning how you came up with the salary slip .thank you

Hi Sir, how to remove blank fields in the mail merge ? For example: Employee 'A' has Conveyance of Rs. 2K ans it shld reflect in the payslips. But employee 'B' doesn't have conveyance and the field should not reflect in the payslip. How to do that in the Excel Word Mail merge ?

How can I run these macro on ms office 2007 as I it is not working there?

Thanks for such a helpful tutorial, but do you know how to creat a password for each attachment?

Is there a way to loop without pressing f8?

Awesome tutorial. Please share the code.

Very nice macro, Dim filename as string to be added

How about if we use Gmail instead of Outlook?

Great. Can you do some modifications on this code to match my needs?! I will pay for those modifications. Kindly reply if you are interested. Thank you.

How to delete exported .pdf files automatically after sending all email?

I have error during this line Set Omail = Oapp.CreateItem(0) what is solution

If salary head not same to everyone how to generate payslip

Very helpful, how to add automatic password to the pdf file of every payslip

Sir can you please explain me how to apply password for each salary slip in VBA to pdf file

Hi user defined not defined error how can I solve this thanks

Having run time error 1004 Pls fix this i am using ms office 2010

Kindly send the VBA spreadsheet I would be great to learn the VBA Code via Excel spreadsheet.

Thanks for this. Could you explain me if I wanna send xls file instead of PDF.

help plz accutly i have multi path like 5 country names folders so each invoice save according to country folder as i have done 'for PDF file save If Range("F26").Value = "Italy" Then Sheet1.Range("B3:K60").ExportAsFixedFormat xlTypePDF, Filename:= _ "C:\Italy\" & Sheet1.Range("J15").Value, OpenAfterPublish:=True End If like above 5 times repeat the codes but my problem is how can i attached patch as attachment in outlook because i have 5 folders path .i want the path to pic the file auto from there own country folder .many thanks

Hi If we want to give the file name as following payslip month Ex: Jan 2017 or Dec 2017, what we have to do. please help.

How to send it by WhatsApp??

getting Runtime error '5' Sheet2.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & "\" & Filename please help m trying to create automated salary slip of my office

Can I escape pdf creation and email sending to the users from the list that don’t have an email address? If so what function will be used?

giving an error Run-time error '5' Invalid procedure call or argument. at export as fixed format row ???

how to use gmail instead of outlook..????

Please share this excel file. This is very useful and powerfull.

Excellent micro, i had the same for salary slips but unfortunately getting error at .Attachments.Add (ThisWorkbook.Path & "\" & Filename) Error Code: 2147024894 (80070002) Cannot find this file. Verify the path and file name are correct. So what's the solution for this.

Could you please share VBA code text?

Error 438, how to overcome it

highly appreciated if u could share vba code here

Dear is there any way to ass a password protection to each PDF

Plz.upload this payroll excel vba file.. for download

Hi sir can you please send me this excel me....it is the great to help to my future

Good work. How do I contact you ?

Bagaimana supaya pdf nya berpassword ? Ada kode vba nya apa tidak ya ?

how do VBA Code to Get PDF of Salary Slip and Send it through whatapp

Video is stuckk

Dear sir , I have a question I have a Sheet with 3 columns Column A =EMPLOYEE ID,i.e 10000-1 Column B=PAYMENT CODES,(101,102,103,304,305,306) column c= Amount i.e (100000,12000,1000,500,20000,3000) Slip sheet and during printing slip programm print Basic Pay (read 101 as Basic pay and other codes) EARNING SIDE i.e (101,102,103) 101 = BASIC PAY, 102=OTHER INC AND 103=PETROL, DEDUCTION SIDE i.e (304,305,306) 304=tax, 305=loan,and 306=EOBI , Earnings Amount Deductions Amount Basic Pay 100000 Tax 500 Other Income 12000 Loan 20000 Petrol 1000 EOBI 3000 Sub Total 113000 23500 Net Pay 89500 If a employee does not have a earning code for example (Petro=306) than its skip and dont show during printing slip and do not show in slip and than print this slip do you have such type of vba code.