12 Python PDF Automation Mail Merge-Generate Bulk PDF Document from Excel, Bulk PDF Invoice Creation

#MailMerge #docxtpl #PythonMailMerge #bulkpdfdocument
#bulkpdfcreationusingpython
#automatepdfcreation
#pythonmailmerge
#pythoncreatepdf
00:00 Intro of Create Bulk PDF from Excel Data
04:00 Python Docxpl Generate Bulk PDF receipts
08:00 Set Word Template to Generate Bulk PDFs using python Docxpl
15:00 Python Create Multiple word documents from Excel Data
20:00 Python How to Generate Bulk PDF documents from excel data using same template
25:00 Python Docxpl to create multiple pdf documents
In this video we will learn how to create BULK PDF POLICY CREATION or BULK PDF CREATION or Creating PDF Document in BULK using data from excel and each document would be separate for each row in excel
Reading Data from excel and do the mapping in word file, loop through each record and create individual pdf document for each customer with no cost
Learn Python - Python Tutorials - Python for Beginners
**********************************************************************************
Python Tutorial Playlist - Setup -
/ python2020

[@rahulteja536]

Thank you brother, hard to find this kind of knowledge sharing videos.

[@artigarg1309]

Tried this while watching your video... Worked well... Thanks to python and thank you for your effort for explaining

[@clyzhang2000]

Thank you very much

[@Raj-ph1py]

Really valuable tutorial.
Thank you

[@Python2020]

Thank you Raj Bhai

[@rajniarora7605]

Supper Solution

[@flutterflowhack]

Very helpful video !!!!! Thank you

[@Python2020]

Your welcome 😊😊

[@sandeepal1]

@Python2020: This is really fantastic tutorial. Really leant a lot. However I have one question in my mind i.e. how to handle if customer name is same and rest all details are different and want to create single invoice for each customer, means multiple records will be there for single customer

[@Python2020]

Thanks a lot sandip for your appreciation, we can keep same name in the template itself if it's only one customer.. Second we can give names in excel rows , multiple rows same name

[@vinayvasi]

Thanks for this useful video. can you make a video with same example for multiple rows of one customer?

[@Python2020]

You mean extract table from PDF..??

[@vinayvasi]

@@Python2020 no, I am talking about mail merge table, df having multiple row items for one customer.
Invoice type thing

[@Python2020]

Please check video no 12 on my channel... That is for pdf creation... For reading pdf table and store that in dataframe you will hv on this weekend

[@ahmedhelal920]

thanks for sharing , but i have question , what if customer have more than one row , how can we deal with that ?

[@Python2020]

@Ahmed Helal - My understanding is that in excel you have multiple rows for same customer which have few related data points in first row and few in another row... For that store unique values in a list from excel column customer name and then loop on the list item , in loop filter entire column by customer then map values to word format... watch video 8-1 to get understanding on pandas filters

[@cpkanojiya]

Sir namaste, this is very usefull video. Sir I have one query that we are use many template. Than how can modify this code. Please suggest me.

[@Python2020]

You can watch video 95 on my channel, install pycharm and write the code

[@akshaysingh7868]

Long Searching Solution of PYTHON PDF GENERATOR

[@RAHULKUMAR-yk3pu]

in this same code we should bulk email through Outlook

[@theplausibleengima2208]

Had any idea how to automate ppt using python with excel

[@Python2020]

Hi, what you want to do in PPT let me know the exact requirement to comment further

[@theplausibleengima2208]

@@Python2020 I have a requirement to read the data from excel using data frame and the data should be sent to ppt that should be aligned in a magazine layout

[@Python2020]

Ok.. I will try from mi side meanwhile try following.
1- covert dataframe to html table
2- add style like header, border by converting html in text and then you can save that as webpage and see if required formatting is available
If these steps are done job will become easy.

[@theplausibleengima2208]

@@Python2020 actually I have some news data it has to be sent to only 1 slide point of view with comparison layout in ppt

[@AkshayPoklekar]

I'm getting error
TypeError: keywords must be string
For line
tpl.render(context [r_index])

[@Python2020]

Are you able to copy the text manually from pdf to Notepad...??

[@AkshayPoklekar]

@@Python2020 pdf not getting generated. I'm getting this error when I run the program

[@Python2020]

Can you share the line of code where this error is coming

[@AkshayPoklekar]

@@Python2020 tpl.render(context[r_index])

[@Python2020]

It works fine... You can try this as well if you want.. I have one more ..Macro to generate pdf from excel... th-cam.com/video/FAxN6-sZdBg/w-d-xo.html