Automate font changing process and mailmerge in Word
Budget: $60 – $70 USD
I require a specialist with proficiency in Word and power automate to create sheets using mailmerge and further use power automate to apply a macro to all papers generated through mailmerge.
Task 1.
From excel sheet generate a set of veterinary case-papers.
The task is mostly done. It requires that certain section of each of the 1000s of pages is selected and then a macro is invoked to change the font of that particular selection.
Task 2
Friom Excel Sheet create mailmerge sheets but
It should pick up data only of certain date and mail-merge it with the form
example all entries of 12/1/2014 should be mailmerged on the form and data of no other date should appear on the form. And a total number of entries with male and female should be auto populated in the appropriate colums.
After the forms are generated with mailmerge. The macro of ctrl-alt-s should apply to all sections with certain fonts.
So, if you are well versed with Ms-word including macros and may be powerautomate. I need your help.
You need to be
Task 1.
From excel sheet generate a set of veterinary case-papers.
The task is mostly done. It requires that certain section of each of the 1000s of pages is selected and then a macro is invoked to change the font of that particular selection.
Task 2
Friom Excel Sheet create mailmerge sheets but
It should pick up data only of certain date and mail-merge it with the form
example all entries of 12/1/2014 should be mailmerged on the form and data of no other date should appear on the form. And a total number of entries with male and female should be auto populated in the appropriate colums.
After the forms are generated with mailmerge. The macro of ctrl-alt-s should apply to all sections with certain fonts.
So, if you are well versed with Ms-word including macros and may be powerautomate. I need your help.
You need to be