Salary Increment PDF Letters from mail merge - Increment PDF लेटर कैसे बनाते है - IPTM Noida
ฝัง
- เผยแพร่เมื่อ 2 ส.ค. 2024
- #Increment #Salary #iptmnoida
Salary Increment PDF Letters from mail merge - Increment PDF लेटर कैसे बनाते है - IPTM Noida.
I will explain below one of the most common practice used in HR - human resource department e.g. Increment Letters Preparation, please follow the all steps. I will refer here following steps and topics:
A Excel sheet with 5000 employee's
A word file which Increment letter template
Mail merge Process
MS word VBA code to generate PDF files from word
MS word VBA code to hide zero value from increment letter for any allowance
MS word VBA code to change authorize signatory's scan signature as per manager name.
Excel VBA Code to set individual password in employee's separates increment letter ( Make sure this will work only if you are using office 32 bit only). Use info excel formula to get to know office version e.g.: =INFO("OSVERSION")
⌚ Timestamps
00:00 Introduction
01:16 Increment Salary Letter Format
02:32 Salary Increment Employee Data in Excel
03:35 MS Word VBA Code for PDF
05:19 Word VBA Training for mail merge for PDF, Hide, Signature
06:50 How to Set Password in All PDFs
07:50 Send individual increment pdf file to employee
09:17 sending email from Excel using outlook
Download: www.payrollpedia.org/how-to-p...
🔔 Channel Subscribe जरूर करे : th-cam.com/users/IptmOrgInak...
_____________________________________________________
☑️Payroll Training Course by IPTM: www.iptm.org.in
☑️New Batch Enquiry: bit.ly/training-enquiry
Payroll Blog: www.payrollpedia.org/
Excel Blog: 99excel.com/home/
Excel Tools: 99excel.com/download
_____________________________________________________
EQUIPMENT’S & SERVICES I USE:
Laptop: amzn.to/3bE0JDD
Webcam: amzn.to/2LqRkVl
Microphone (Boya): amzn.to/2LtEMMW
4K Ultra HD Smart LED TV: amzn.to/3ssTNPD
Chromakey Green Scree: amzn.to/3sAMbL9
I RECOMMEND:
Start Own Busines Online: amzn.to/39AEOua
Get Amazon Prime: amzn.to/2LU0bPe
Best Hosting (hostgator): bit.ly/3oJDzPD
Find People and Services: fwd.cx/NVOg9i3VfkSS
CREATED BY:
Ajit Kumar Yadav (AKumar)
Follow Me on Instagram: / akumar0808
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Thanks for coming over here.
#iptmnoida #99Excel
Informative video 😊
Superb 👍👍👍👍
Theeno sheets kese banaie, please use bhi samjhaye Sir.
What if each PDF should have 2 pages per employee?
Excel and Word files r missing. cld u plz share?
Sir please provide VBA code
i have 64 Bit NT 10. Can you suggest utility for this
No. Only 32 bit support
If file is 2 page what is the code?
But Sir how to download for Windows 64 bit?
VAB Code Missing, Kindly share on my mail
What if each PDF should have 3 pages per employee?
do page setting
@@Indianpayroll how to do page setting sir
VAB Code Missing
Cyto no.p22 - 64 85. Pdf copy.
How to hide if three columns in table
.text use and hide it using loop
pLEASE SHARE vba code
from where I get get excel file of password
Buy it