How to Automate Word Documents Using Python

In this video, I show how to automate Microsoft Word with Python. We'll generate multiple cover letters by extracting data from Excel.

--------------------
Content:
0:00 Intro
0:27 Fill in Word template with Python
8:05 Generating multiple word documents with Python

[tiagoandreotti]

Frank, thank you for this video. It was very helpful!

[crystalcleargirl]

🎉 wow, this is so helpful! thank you for making this video tutorial!

[adrianmerc_c]

Excelente video, Muchas gracias Frank, me va a servir de mucho

[joseluisgalancabilla]

Excellent!!! Many thanks!
Instead of generating one doc for each row, it is possible to generate each letter as a page of the same document? I would like to apply this not for generating letters, but for generating, for example, bibliographic references.

[bluemonk]

Fantastic tutorial, it really helped me out! I have a small question though, I'm trying to add text to a text box. How can I align the string from python in the middle? I tried changing the textbox settings in word but python ignores this and aligns bottom

[afreenaamran]

Hi sir. Thanks for this. I have a question. Do you know how to make it possible to choose different excel file everytime I want to automate the word document?
I want to use the same docs template, but with different excel files.

[gaben_aTan]

Perfect method! and how to make one word document from several when iterating?

[ninatyminska]

Thanks for the tutorial, it's very helpful. One question how could I modify the code so that the name of newly generated document was instead of generated_doc_{index}.docx ? Knowing that context = {'first_name': row['first'],
'last_name': row['last']}

[utube]

Thank you for the great video! One query: Is it possible to update the status of checkboxes? If so, how?

[eerd]

which tool you using to creat the pyton script?

[Hex-Scholar]

Thank you for this awesome tutorial, using Jinja in Flask recently was fascinating and now knowing you can use it with word documents will surely be time saving. I have one question is it possible to fill each template within the same file but different pages ?

[sanathkumarr]

its generating different documents with the same data

[sowmiya]

how to update table of content dynamically

[siconova]

It's there something similar but for sheets and docs from Google?

[Carlo.D]

excellent tutorial... I wanted to create an exe but the 'docxtpl' module is giving me problems *ModuleNotFoundError: No module named 'docxtpl'*executable ? can U give me some explanation? tks

[AnkitSharma-bozj]

Hi I am getting a KeyError on the name of the row. How to resolve this?

[amj.composer]

Thank you so much, now I'm gonna apply to so many fucking jobs lmfao

[sanathkumarr]

But printing context shows different data

[KarmveerChauhan-opsq]

how can i automate all the data to the same word file ?

[pushpanshuasthana]

I am getting this error in email automation, please resolve it...

em['From'] = email_sender
TypeError: 'type' object does not support item assignment