This bot will create an offer letter from a template using employees data from an Excel sheet.
- Replace the template file “test.docx” with your own offer letter format inside the "My Inputs” folder
- Create bookmarks as per requirements
- Follow steps for mapping the bookmarks:
- “WordMetabot.LaunchWord” logic to launch Microsoft Office Word application
- “WordMetabot.OpenDocument” logic to open document
- Use “WordMetabot.InsertTextAtBookmark” logic to insert text at each bookmark created inside the Word document template
- Save the document using “WordMetabot.SaveDocument” logic
- Close and save the word document using “WordMetabot.CloseWordSaveAllChanges” logic
- Use “Text_Word_PDF_Conversion_Metabot.Word_to_PDF_Files_Logic” logic to convert docx file format to PDF file format
- Maintain "input file.xlsx" from "My Inputs" folder as per the bookmarks and other requirements