VBA Code to Get PDF of Salary Slip and Send it through Email

[@doobiegirl09]

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

[@sorinpetcu7503]

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

[@12thAnalytics]

Glad it helped!

[@AbChanAeri]

Really helpful tutorial. I subscribed!

[@miki_5914]

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?

[@nyamdulamnyamjav77]

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

[@jennyyap3839]

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"

[@rangaswamys]

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?

[@homrajshrestha3338]

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

[@thres34]

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

[@nhatlinhnguyen8823]

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

[@mamah88]

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.

[@mahmudshopan6004]

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.

[@abdullahquhtani4247]

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.

[@12thAnalytics]

Hi Abdullah! Thanks for your consideration. Yes, I would love to work on that. Please respond at [e-mail]

[@AbdullaKhizamworld]

@@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

[@ghadeersaad8810]

How to send it by WhatsApp??

[@oudomang5613]

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

[@karthikkv9735]

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 ?

[@manojkumarpatel1131]

Ek no. Bro thank you so much❤

[@jayshrimishra3350]

Very nice macro, Dim filename as string to be added

[@narayanareddygade3451]

Hi can you please send this macro working for this VBA creation, please send me the working to my email id [e-mail], please

[@DavidAntwiBoasiako]

Thank you very much once again.

[@danielkwesiyanney4852]

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

[@priyanthagamini3860]

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

[@MrKisspie]

Is there a way to loop without pressing f8?

[@slamatale5480]

Great work,

[@mohamedsulfiker.m.y9914]

Thankyou sir for this lesson

[@AbdullaKhizamworld]

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

[@ashrafalhussain5093]

Hi if you aware please share with us

[@AbdullaKhizamworld]

@@ashrafalhussain5093 still unable to figure it out. even learning to get it but hope someone help me out soon.

[@asadulislamasad4985]

Thanks sir ji

[@sumit_singh684]

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

[@ssconsult3791]

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

[@jennyyap3839]

How about if we use Gmail instead of Outlook?

[@9901028711]

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

[@cpkanojiya]

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

[@amazon5665]

highly appreciated if u could share vba code here

[@globalfoundry2912]

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

[@himabeah2181]

Me too

[@suranjithkhrishantha6997]

Me tooo

[@TheRajKusum]

very helpful. thank you.

[@hassanjatta4257]

Awesome tutorial. Please share the code.

[@corisehealthcare7956]

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

[@punyashlokahilyadeviholkar5019]

I have also same problem sir. Have you got solution ?

[@jennyyap3839]

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?

[@raghuram45]

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.

[@mamah88]

L

[@markraveneilmartinez305]

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

[@manasimalekar2293]

If salary head not same to everyone how to generate payslip

[@gganaggene6906]

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?

[@12thAnalytics]

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

[@TanmoyDaw]

Twelfth Analytics Sir, PDF generation function is not working its Run Time Error Invalid Procedure cell or argument.!! Kindly advice??

[@vv9730]

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

[@Nextwhatguru]

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.

[@Nextwhatguru]

and its working well without attachment.

[@slamatale5480]

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

[@imranashraf2530]

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

[@12thAnalytics]

Hi Imran sorry for late reply. Is your issue still exist. I will share the solution, if you have the issue.

[@imranashraf2530]

yes please share

[@talalbalexco7172]

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

[@TimKanya]

I would also like to know how to generate this.

[@sharmajisuperhit]

Could you please share VBA code text?

[@sreejondey1917]

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

[@lamphokeopanya9831]

Thanks man

[@septaputra9315]

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

[@SanviPatil2019]

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

[@hradmin8805]

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

[@karthikswaminathan1124]

Good work. How do I contact you ?

[@12thAnalytics]

Hi! Thanks. Sorry for late reply. You can contact me at [e-mail]

[@narayanareddygade3451]

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

[@sivabharath9478]

Error 438, how to overcome it

[@soohailakhtar]

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.

[@appu331]

Video is stuckk