How to Automate Microsoft Word Mail Merge with Python

  Рет қаралды 14,355

Jie Jenn

Jie Jenn

Күн бұрын

Пікірлер: 16
@monroebayer783
@monroebayer783 3 жыл бұрын
Thanks for the great tuts, can you elaborate this one , loading from 2 csv ? having a mutual key un each file ?
@senahugtfl7789
@senahugtfl7789 2 жыл бұрын
hi ı have a issue when ı was writing my file path .According to the internet i ve written correct but for ATOM accepted if I only write full absolute path starting ffrom "C:".And it is so unfit could you hepl me ?
@SymphOcta
@SymphOcta 3 жыл бұрын
Very helpful, thank you!
@basavrajr8577
@basavrajr8577 3 жыл бұрын
can we do-- which are number of mails we are getting as report from Jenkins 1)convert into word and merge that word file and send this report to one mail_id or 2) combine different mail and send to single mail id ---with python
@jiejenn
@jiejenn 3 жыл бұрын
Pretty sure it is doable.
@TheButcher58
@TheButcher58 4 жыл бұрын
Nice tutorial, I do have one question tho, I have a mail merged setup in microsoft publisher rather than word, would this code also work if I change it slightly to use publisher rather than word?
@jiejenn
@jiejenn 4 жыл бұрын
I never work with Publisher VBA before, but I do know you can access Publisher's VBA data model with pywin32. So my take is you should be able to, b it the difficult part is how to use Publisher's objects.
@TheButcher58
@TheButcher58 4 жыл бұрын
@@jiejenn yes thanks, I’ve looked for some documentation but apparently the vba objects in publisher are different from word so it will be a challenge. I guess I’ll leave it as it is for now
@KhalilYasser
@KhalilYasser 4 жыл бұрын
Amazing. Thanks a lot for this great tutorial. Can you share the code and the files, please?
@wibowomalik
@wibowomalik 3 жыл бұрын
Video about how to export a mail merge document individually with name from selected merge field value to pdf. Please.
@danielamegah1324
@danielamegah1324 3 жыл бұрын
You can just export the word file into pdf
@obi-wankenobi2715
@obi-wankenobi2715 3 жыл бұрын
How to make only one document with all the documents? Instead of getting multiple documents
@jiejenn
@jiejenn 3 жыл бұрын
A regular mail merge by default will output all the documents in one single document.
@saurabhpakhurde
@saurabhpakhurde 3 жыл бұрын
I am getting at Name:=
@jaceiscool123
@jaceiscool123 3 жыл бұрын
I am getting a syntax error at "Name:=" as well. Why am I get this?
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
She made herself an ear of corn from his marmalade candies🌽🌽🌽
00:38
Valja & Maxim Family
Рет қаралды 18 МЛН
Automate Mail Merge with Excel Database using VBA (Macro)
15:15
How to Replace VBA with Python(Step-By-Step Tutorial)
31:19
Excel Macro Mastery
Рет қаралды 270 М.
docxtpl python library for creating automated reports from word templates
19:31
Will Python Kill Excel VBA?
12:39
Excel Macro Mastery
Рет қаралды 341 М.