Friday, October 15, 2021

How to create MS Word document automatically with Excel

MS Word and Excel can do wonders together.  You can do a lot of automation using these 2 applications for your small and medium businesses.  Here is one such solution.  

Generating the MS word report automatically using excel as a data source. Mail merge is used to link data from excel to word. Then a simple macro is used to get the desired record from Excel Spreadsheet.

Download the MS word document and Excel spreadsheet used in this video here

https://drive.google.com/drive/folders/0B4UB3eOhhY26TVdvQ3RucW1zb1E?resourcekey=0-YcGX4_XdYqt_C_dSztvA_A&usp=sharing

If you are not able to access this link, let me know. The link in my YouTube channel was not working, now I have uploaded the files here. 

No comments:

Post a Comment

How to set Python3 as default interpreter for VS Code | or set any version as default interpreter.

Want to run your python code with a particular python version? And, make it the default version? Read on.. Make sure that the required versi...