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
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?
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"
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.
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.
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?
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 ?
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.
@@12thAnalyticshey could you please share me you correct email as I haved the following mail but never responded. I have been trying to know small modification as to send Excel file not PDF. please reply
getting Runtime error '5' Sheet2.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & "\" & Filename please help m trying to create automated salary slip of my office
I've also encountered this problem. It says " Document not saved. The document may be open, or an error nay have been encountered when saving". Can you help me with this?
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 Gana, please use below code to skip creating emails for employees having no email address. Sub PrintSalarySlips() Dim Oapp As Outlook.Application Dim Omail As Object a = 1 Do While a
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.
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.
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
Great vb code. I have saved a lot of time. 😀 Thank you
Glad it helped!
Really helpful tutorial. I subscribed!
Big thank you sir, your video made my task much easier.
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?
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"
How to send it by WhatsApp??
Thank you very much for the video, Can use Gmail instead of outlook?
Thanks for such a helpful tutorial, but do you know how to creat a password for each attachment?
Ek no. Bro thank you so much❤
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.
Very helpful, how to add automatic password to the pdf file of every payslip
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.
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 once again.
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 ?
Really appreciated, such a helpful tool, if possible, I would like to know how to design more attractive body email.
Great work,
Thankyou sir for this lesson
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.
Hi Abdullah! Thanks for your consideration. Yes, I would love to work on that. Please respond at 12thAnalytics@gmail.com
@@12thAnalyticshey could you please share me you correct email as I haved the following mail but never responded. I have been trying to know small modification as to send Excel file not PDF. please reply
Very nice macro,
Dim filename as string to be added
Hi can you please send this macro working for this VBA creation, please send me the working to my email id narayana142712@gmail.com.Please, please
very helpful. thank you.
Thanks sir ji
getting Runtime error '5'
Sheet2.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & "\" & Filename
please help
m trying to create automated salary slip of my office
I have also same problem sir. Have you got solution ?
I've also encountered this problem. It says " Document not saved. The document may be open, or an error nay have been encountered when saving". Can you help me with this?
I have error during this line Set Omail = Oapp.CreateItem(0) what is solution
giving an error Run-time error '5' Invalid procedure call or argument. at export as fixed format row ???
Me too
Me tooo
Thanks for this. Could you explain me if I wanna send xls file instead of PDF.
Hi if you aware please share with us
@@ashrafalhussain5093 still unable to figure it out. even learning to get it but hope someone help me out soon.
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.
L
Sir can you please explain me how to apply password for each salary slip in VBA to pdf file
How can I run these macro on ms office 2007 as I it is not working there?
Is there a way to loop without pressing f8?
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 Imran sorry for late reply. Is your issue still exist. I will share the solution, if you have the issue.
yes please share
How about if we use Gmail instead of Outlook?
please can you show me me from the beginning how you came up with the salary slip .thank you
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?
Hi Gana, please use below code to skip creating emails for employees having no email address.
Sub PrintSalarySlips()
Dim Oapp As Outlook.Application
Dim Omail As Object
a = 1
Do While a
Twelfth Analytics Sir, PDF generation function is not working its Run Time Error Invalid Procedure cell or argument.!!
Kindly advice??
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.
and its working well without attachment.
Awesome tutorial. Please share the code.
highly appreciated if u could share vba code here
Thanks man
Hi user defined not defined error how can I solve this thanks
Please share this excel file. This is very useful and powerfull.
How to delete exported .pdf files automatically after sending all email?
how to use gmail instead of outlook..????
If salary head not same to everyone how to generate payslip
Kindly send the VBA spreadsheet I would be great to learn the VBA Code via Excel spreadsheet.
Having run time error 1004
Pls fix this i am using ms office 2010
Dear is there any way to ass a password protection to each PDF
I would also like to know how to generate this.
Bagaimana supaya pdf nya berpassword ? Ada kode vba nya apa tidak ya ?
Could you please share VBA code text?
Plz.upload this payroll excel vba file.. for download
how do VBA Code to Get PDF of Salary Slip and Send it through whatapp
Good work. How do I contact you ?
Hi! Thanks. Sorry for late reply. You can contact me at 12thAnalytics@gmail.com
Error 438, how to overcome it
Hi sir can you please send me this excel me....it is the great to help to my future
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.
Video is stuckk