![]() Row G: Shows the status (if the letter is generated it shows "Letter Generated Already" after running the macro or it shows blank if it is new record entered.Īlso how can I save the output (merged file) also in PDF other than DOC file so the merged files will be in two formats one in DOC and the other one in PDF formats? Sub MergeMe() Example: if my Excel has 5 Employee details I am able to save the 5 individual merged files on each employee name, however the merged data if of the first employee who is in Row 2. The problem is the output in all the merged files the output is same as the first row. And every time it runs the file for one person it will give the status as Letter Already Generate so that it wont duplicate any Employee records. ![]() I have run mail-merge automatically and save individual files as per the Employee name. I have Employee data in Excel and I can generate any Employee letter using that Data and can save the individual Employee letter as per the Employee name. I created a macro in Excel where I can mail-merge data from Excel into Word Letter Template and save the individual files in the folder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |